O'Reilly logo
  • Wiktor Bojanowski thinks this is interesting:

“Compile a complete list of vendor names and addresses in vendor name order.”

From

Cover of SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Fourth edition

Note

SELECT VendName, VendStreetAddress, VendCity, VendState, VendZipCode FROM Vendors ORDER BY VendName;