Database: cinema
Question: Show all the locations where some cinemas were opened in both year 2010 and year 2011.
SQL:
SELECT LOCATION FROM cinema WHERE openning_year  =  2010 INTERSECT SELECT LOCATION FROM cinema WHERE openning_year  =  2011