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