SELECT LOCATION FROM shop WHERE Open_Year  >  2012 INTERSECT SELECT LOCATION FROM shop WHERE Open_Year  <  2008
Show the locations shared by shops with open year later than 2012 and shops with open year 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
Show the locations shared by shops with open year later than 2012 and shops with open year before 2008 .