Amazon Interview Question
5. Find customers with 3+ orders in 2014
Interview Answer
Anonymous
Jun 23, 2025
SELECT customer_id FROM orders WHERE order_date BETWEEN '2014-01-01' AND '2014-12-31' GROUP BY customer_id HAVING COUNT(DISTINCT order_id) >= 3;