Show all the shop names and the location
select shop_name, location from shop
Keep those shops which opened in January.
select shop_name, location from shop where open_date like "%jan%"
Keep 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