List the names and open year of all the shops.
select shop_name, open_year from shop
Keep those opens later than 2010?
select shop_name, open_year from shop where open_year > 2010
Order all the shop names by the open year, from early to late.
select shop_name, open_year from shop order by open_year
Show the name of the shop with the latest open year.
select shop_name from shop order by open_year desc limit 1