Database: cinema
Question: Show the cinema name and location for cinemas with capacity above average.
SQL:
SELECT name ,  LOCATION FROM cinema WHERE capacity  >  (SELECT avg(capacity) FROM cinema)