How many cinemas are there in total?
select count ( * ) from cinema
What is the average capacity?
select avg ( capacity ) from cinema
How many cinemas have above average capacity?
select count ( * ) from cinema where capacity > ( select avg ( capacity ) from cinema )
What is the name and location of the 2 cinemas with above average capacity?
select name, location from cinema where capacity > ( select avg ( capacity ) from cinema )