Database: device
Question: What are the names and location of the shops in ascending alphabetical order of name.
SQL:
SELECT Shop_Name ,  LOCATION FROM shop ORDER BY Shop_Name ASC