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
### Context: 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. ### Answer: SELECT LOCATION FROM cinema WHERE openning_year = 2010 INTERSECT SELECT LOCATION FROM cinema WHERE openning_year = 2011