How many different cinemas are on the list?
select count ( distinct cinema_id ) from cinema
What is the average capacity of each cinema?
select avg ( capacity ) from cinema
Which cinema has the highest capacity, and which has the lowest capacity?
select name from cinema where capacity = ( select min ( capacity ) from cinema ) or capacity = ( select max ( capacity ) from cinema )
Which locations have the most cinemas?
select location from cinema group by location order by count ( * ) desc limit 1
Which location has the most cinemas opened in 2010 or later?
select location from cinema where openning_year > = 2010 group by location order by count ( * ) desc limit 1