Database: device
Question: Show the locations shared by shops with open year later than 2012 and shops with open year before 2008.
SQL:
SELECT LOCATION FROM shop WHERE Open_Year  >  2012 INTERSECT SELECT LOCATION FROM shop WHERE Open_Year  <  2008