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

“Display a list of all bowlers and addresses formatted suitably for a mailing list, sorted by ZIP Code.”

From

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

Note

SELECT CONCAT(BowlerLastName, " ", BowlerFirstName) AS BowlerName, CONCAT(BowlerAddress, ", ", BowlerCity, ", ", BowlerState, ", ", BowlerZip) AS BowlerAddress FROM Bowlers ORDER BY BowlerZip;