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)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE cinema (name VARCHAR, LOCATION VARCHAR, capacity INTEGER) Question: Show the cinema name and location for cinemas with capacity above average. [/INST] SELECT name, LOCATION FROM cinema WHERE capacity > (SELECT AVG(capacity) FROM cinema) </s>