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

“Give me a list of customers who placed orders in May.”

From

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

Note

SELECT CustomerID, OrderDate FROM Orders WHERE OrderDate LIKE "20__-05-__";