Загрузка данных


SELECT c.name AS customer_name, COUNT(*) AS order_count
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
WHERE o.order_placed BETWEEN '2024-03-02' AND '2024-03-31'
GROUP BY c.customer_id
ORDER BY order_count DESC
LIMIT 5;