PostgreSQLMySQL / MariaDBSQLiteStandard ANSI SQLUPPERCASE Keywords ✓

Reset Sample

Source InputClear

SELECT u.id, u.username, u.email, count(o.id) as total_orders, sum(o.amount) as total_spent FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.active = true AND o.created_at >= '2026-01-01' GROUP BY u.id, u.username, u.email HAVING count(o.id) > 5 ORDER BY total_spent DESC LIMIT 20;

Formatted OutputCopy

SELECT u.id, u.username, u.email, count(o.id) AS total_orders, sum(o.amount) AS total_spent FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.active = TRUE AND o.created_at >= '2026-01-01' GROUP BY u.id, u.username, u.email HAVING count(o.id) > 5 ORDER BY total_spent DESC LIMIT 20;