Database: device
Question: Which locations contains both shops that opened after the year 2012 and shops that opened before 2008?
SQL:
SELECT LOCATION FROM shop WHERE Open_Year  >  2012 INTERSECT SELECT LOCATION FROM shop WHERE Open_Year  <  2008