Pergunta de entrevista da empresa Amazon
5. Find customers with 3+ orders in 2014
Resposta da entrevista
Sigiloso
23 de jun. de 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;