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
Show me all film studios in record.
assistant
SELECT distinct Studio FROM FILM;
human
Which ones contain the word 'Universal'?
assistant
SELECT distinct Studio FROM FILM WHERE Studio LIKE '%Universal%';
human
Show me the titles of their films along with their name.
assistant
SELECT title , Studio FROM film WHERE Studio LIKE "%Universal%" ;