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

“Show me a list of orders made by each customer in descending date order.”

From

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

Note

SELECT * FROM Orders ORDER BY CustomerID, ShipDate DESC;