SELECT user_id, SUM(amount) AS total_spend
FROM orders
WHERE created_at >= '2026-01-01'
AND created_at < '2027-01-01'
GROUP BY user_id
ORDER BY total_spend DESC
LIMIT 5;
This sums each user’s order amounts during 2026 and returns the five highest totals.