CREATE TABLE cinema (name VARCHAR2, LOCATION VARCHAR2, capacity NUMBER)

Show the cinema name and location for cinemas with capacity above average.
SELECT name, LOCATION FROM cinema WHERE capacity > (SELECT AVG(capacity) FROM cinema)
SELECT "name", "LOCATION" FROM "cinema" WHERE "capacity" > (SELECT AVG("capacity") FROM "cinema")