Given a table where a business has multiple customers, write a SQL query that returns each customer ID and the total number of orders they placed in 2025, filtering only customers with more than five orders.

The solution is the same as the previous examples:

SELECT customer_id,

   COUNT(*) AS total_orders

FROM Orders

WHERE YEAR(order_date) = 2025

GROUP BY customer_id

HAVING COUNT(*) > 5;

This groups orders by customer, counts them, and keeps only those groups where the count exceeds five. The query is efficient if an index exists on order_date or a composite index on (order_date, customer_id).