text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE shop (LOCATION VARCHAR, Open_Year INTEGER)
  ### Question:
  Show the locations shared by shops with open year later than 2012 and shops with open year before 2008.
  ### Answer:
  SELECT LOCATION FROM shop WHERE Open_Year > 2012 INTERSECT SELECT LOCATION FROM shop WHERE Open_Year < 2008