Show the cinema name and location for cinemas with capacity above average.
CREATE TABLE cinema (name VARCHAR, LOCATION VARCHAR, capacity INTEGER)
[SQL] SELECT name, LOCATION FROM cinema WHERE capacity > (SELECT AVG(capacity) FROM cinema) [/SQL]