Show the cinema name and location for cinemas with capacity above average.
CREATE TABLE cinema (name VARCHAR, LOCATION VARCHAR, capacity INTEGER)
SELECT name, LOCATION FROM cinema WHERE capacity > (SELECT AVG(capacity) FROM cinema)
### Context: CREATE TABLE cinema (name VARCHAR, LOCATION VARCHAR, capacity INTEGER) ### Question: Show the cinema name and location for cinemas with capacity above average. ### Answer: SELECT name, LOCATION FROM cinema WHERE capacity > (SELECT AVG(capacity) FROM cinema)