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
Hello, which films where made in 1995?
assistant
SELECT * FROM film AS T1 JOIN film_market_estimation AS T2 ON T1.Film_ID = T2.Film_ID WHERE T2.Year = 1995;
human
Who was the distinct director of ET the Extra-Terrestrial?
assistant
SELECT director FROM film WHERE title = 'ET the Extra-Terrestrial';
human
Can you show me Market estimation for the year 1995?
assistant
SELECT low_estimate , high_estimate FROM film_market_estimation WHERE Year = 1995 ;