SELECT LOCATION FROM shop WHERE Open_Year  >  2012 INTERSECT SELECT LOCATION FROM shop WHERE Open_Year  <  2008
Which locations contains both shops that opened after the year 2012 and shops that opened before 2008?
SELECT LOCATION FROM shop WHERE Open_Year > 2012 INTERSECT SELECT LOCATION FROM shop WHERE Open_Year < 2008
select location from shop where open_year > value intersect select location from shop where open_year < value
Which locations contains both shops that opened after the year 2012 and shops that opened before 2008 ?