SELECT Shop_Name ,  LOCATION FROM shop ORDER BY Shop_Name ASC
What are the names and location of the shops in ascending alphabetical order of name.
SELECT Shop_Name , LOCATION FROM shop ORDER BY Shop_Name ASC
select shop_name , location from shop order by shop_name asc
What are the names and location of the shops in ascending alphabetical order of name .