Find the locations that have more than one movie theater with capacity above 300.
CREATE TABLE cinema (LOCATION VARCHAR, capacity INTEGER)
SELECT LOCATION FROM cinema WHERE capacity > 300 GROUP BY LOCATION HAVING COUNT(*) > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE cinema (LOCATION VARCHAR, capacity INTEGER) Question: Find the locations that have more than one movie theater with capacity above 300. [/INST] SELECT LOCATION FROM cinema WHERE capacity > 300 GROUP BY LOCATION HAVING COUNT(*) > 1 </s>