CREATE TABLE device (device_id NUMBER, device CLOB, carrier CLOB, package_version CLOB, applications CLOB, software_platform CLOB)
CREATE TABLE shop (shop_id NUMBER, shop_name CLOB, location CLOB, open_date CLOB, open_year NUMBER)
CREATE TABLE stock (shop_id NUMBER, device_id NUMBER, quantity NUMBER)

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" > 2012 INTERSECT SELECT "location" FROM "shop" WHERE "open_year" < 2008