For each customer ID, write a SQL query that returns the total number of orders they placed in 2025, but only if that total is greater than five.

Question

Assisting AI · Accepted Answer

Use GROUP BY to aggregate per customer and HAVING to filter the count:

SELECT customer_id,
       COUNT(*) AS total_orders
FROM Orders
WHERE YEAR(order_date) = 2025
GROUP BY customer_id
HAVING COUNT(*) > 5;

This returns a row for each customer with more than five orders in 2025. The query runs in linear time relative to the number of orders in the table.

💡 Model Answer