Database: device
Question: Return the names and locations of shops, ordered by name in alphabetical order.
SQL:
SELECT Shop_Name ,  LOCATION FROM shop ORDER BY Shop_Name ASC