Show all the locations where some cinemas were opened in both year 2010 and year 2011.
CREATE TABLE cinema (LOCATION VARCHAR, openning_year VARCHAR)
SELECT LOCATION FROM cinema WHERE openning_year = 2010 INTERSECT SELECT LOCATION FROM cinema WHERE openning_year = 2011
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE cinema (LOCATION VARCHAR, openning_year VARCHAR) Question: Show all the locations where some cinemas were opened in both year 2010 and year 2011. [/INST] SELECT LOCATION FROM cinema WHERE openning_year = 2010 INTERSECT SELECT LOCATION FROM cinema WHERE openning_year = 2011 </s>