What is are the capacities for cinemas?
select capacity from cinema
What is the average?
select avg(capacity) from cinema
Show the name and location for any cinemas with a capacity above this.
select name, location from cinema where capacity > (select avg(capacity) from cinema)