What are the names and location of the shops in ascending alphabetical order of name.
create table shop (shop_name varchar, location varchar, PRIMARY KEY (shop_name))
select shop_name, location from shop order by shop_name