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

“How many days elapsed between the order date and the ship date for each order?”

From

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

Note

SELECT OrderNumber, OrderDate, ShipDate, (ShipDate - OrderDate) AS DaysToShip FROM Orders;