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