IntermediateWHERE & Filtering

Find customers who joined in Q1 of any year

The query

SQL

SELECT name, joined_at, country
FROM customers
WHERE EXTRACT(MONTH FROM joined_at) IN (1, 2, 3)
ORDER BY joined_at DESC;

Tested against PostgreSQL 16

Note

“EXTRACT(MONTH) returns 1-12. Q1 = months 1,2,3. Use for seasonal analysis.