SQL Formatter & Beautifier

WITH user_orders AS ( SELECT u.id AS user_id, u.email, u.created_at, COUNT(o.id) AS total_orders, SUM(o.amount) AS lifetime_spend, rank() OVER (PARTITION BY u.country ORDER BY SUM(o.amount) DESC) AS country_spend_rank FROM users u LEFT JOIN orders o ON o.user_id = u.id AND o.status = 'completed' WHERE u.status = 'active' AND u.created_at >= '2025-01-01' GROUP BY u.id, u.email, u.created_at, u.country HAVING COUNT(o.id) > 2 ) SELECT * FROM user_orders WHERE country_spend_rank <= 10 ORDER BY lifetime_spend DESC LIMIT 50;