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
What is the average for all movies? | average what? | Sorry, the average budget for all movies?
assistant
SELECT AVG ( budget_million ) FROM movie;
human
Okay. What is the average budget for all movies before 2000?
assistant
SELECT AVG ( budget_million ) FROM movie WHERE year < 2000;
human
Finally, what is the average budget, the maximum budget, and the minimum budget for all movies before 2000?
assistant
SELECT AVG ( budget_million ) , MAX( budget_million ) , MIN( budget_million ) FROM movie WHERE YEAR < 2000 ;