-- Database schema
| device : Device_ID [ INT ] primary_key , Device [ TEXT ] , Carrier [ TEXT ] , Package_Version [ TEXT ] , Applications [ TEXT ] , Software_Platform [ TEXT ] | shop : Shop_ID [ INT ] primary_key , Shop_Name [ TEXT ] , Location [ TEXT ] , Open_Date [ TEXT ] , Open_Year [ INT ] | stock : Shop_ID [ INT ] primary_key stock.Shop_ID = shop.Shop_ID , Device_ID [ INT ] stock.Device_ID = device.Device_ID , Quantity [ INT ] |
-- -- 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;