Show the capacities for all cinemas.
select capacity from cinema
How about the capacities for those that opened in 2011 or later?
select capacity from cinema where openning_year >= 2011
What is the average, minimum, and maximum among these?
select avg(capacity), min(capacity), max(capacity) from cinema where openning_year >= 2011