List the locations where a cinema was opened in 2010.
select location from cinema where openning_year = 2010
How about the locations where of cinema was opened in 2011?
select location from cinema where openning_year = 2011
Show the locations that belong to both groups.
select location from cinema where openning_year = 2010 intersect select location from cinema where openning_year = 2011