human
Schema:
film (Film_ID, Title, Studio, Director, Gross_in_dollar)
market (Market_ID, Country, Number_cities)
film_market_estimation (Estimation_ID, Low_Estimate, High_Estimate, Film_ID, Type, Market_ID, Year)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the average gross amount of money made in dollars?
assistant
SELECT AVG ( gross_in_dollar ) FROM film;
human
What films did Nicholas Meyer direct?
assistant
SELECT Title FROM film WHERE Director = 'Nicholas Meyer';
human
What were those movies directed by Walter Hill?
assistant
SELECT Title FROM film WHERE Director = 'Walter Hill';
human
What studio produced that movie with name 48 Hrs?
assistant
SELECT Studio FROM film WHERE Title = '48 Hrs';
human
What studio produced Star Trek II: The Wrath of Khan?
assistant
SELECT Studio FROM film WHERE Title = "Star Trek II: The Wrath of Khan" ;