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

“Give me the names of all our customers by city.”

From

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

Note

SELECT CustCity, CONCAT(CustFirstName, " ", CustLastName) AS CustName FROM Customers ORDER BY CustCity;