Show me the open year of all shops in numerical order.
select open_year from shop order by open_year
Show the locations shared by shops.
select location from shop group by location having count ( * ) > 1
Show the shops with open year later than 2012 and open year before 2008.
select shop_name from shop where open_year > 2012 or open_year < 2008