Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE device ( device_id number, device text, carrier text, package_version text, applications text, software_platform text )
TABLE: CREATE TABLE shop ( shop_id number, shop_name text, location text, open_date text, open_year number )
TABLE: CREATE TABLE stock ( shop_id number, device_id number, quantity number )

### Question ###
Show the locations shared by shops with open year later than 2012 and shops with open year before 2008.

### Accurate SQL ###

SELECT location FROM shop WHERE open_year > 2012 INTERSECT SELECT location FROM shop WHERE open_year < 2008