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