human
Schema:
film (Film_ID, Rank_in_series, Number_in_season, Title, Directed_by, Original_air_date, Production_code)
cinema (Cinema_ID, Name, Openning_year, Capacity, Location)
schedule (Cinema_ID, Film_ID, Date, Show_times_per_day, Price)
Please answer with SQL.
assistant
Sure, I understand.
human
How many different cinemas are on the list?
assistant
SELECT COUNT( distinct cinema_id ) FROM cinema;
human
What is the average capacity of each cinema?
assistant
SELECT AVG ( capacity ) FROM cinema;
human
Which cinema has the highest capacity, and which has the lowest capacity?
assistant
SELECT name FROM cinema WHERE capacity = ( SELECT MIN( capacity ) FROM cinema ) OR capacity = ( SELECT MAX( capacity ) FROM cinema ) ;