human
Schema:
book_club (book_club_id, Year, Author_or_Editor, Book_Title, Publisher, Category, Result)
movie (movie_id, Title, Year, Director, Budget_million, Gross_worldwide)
culture_company (Company_name, Type, Incorporated_in, Group_Equity_Shareholding, book_club_id, movie_id)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the title and director for all movies.
assistant
SELECT title , director FROM movie;
human
Only show the results for those in the year 2000 or before.
assistant
SELECT title , director FROM movie WHERE YEAR <= 2000;
human
Order the results by the worldwide gross in descending order.
assistant
SELECT title , director FROM movie WHERE YEAR <= 2000 ORDER BY gross_worldwide DESC ;