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
How many films are there in total?
assistant
SELECT COUNT( DISTINCT Title ) FROM film;
human
How many of those films do not have any market estimation?
assistant
SELECT COUNT( Title ) FROM film WHERE Film_ID NOT IN ( SELECT Film_ID FROM film_market_estimation );
human
What about film IDs? | Do you mean the film IDs of the 9 films that do not have market estimations? | Yes, could you tell me those films' IDs?
assistant
SELECT film_ID FROM film WHERE Film_ID NOT IN ( SELECT Film_ID FROM film_market_estimation ) ;