SQL Formatter
Format messy SQL queries for readability or minify them for production. Supports SELECT, INSERT, UPDATE, DELETE, JOINs, CTEs and more.
✏️ SQL Input376 chars
✨ Formatted SQL
SELECT u.id ,
u.name ,
u.email ,
o.order_id ,
o.total ,
p.product_name
FROM users u
INNER JOIN orders o
ON u.id = o.user_id
LEFT JOIN order_items oi
ON o.order_id = oi.order_id
LEFT JOIN products p
ON oi.product_id = p.id
WHERE u.active = 1
AND o.created_at >= '2024-01-01'
AND o.total > 100
GROUP BY u.id ,
u.name ,
o.order_id
HAVING COUNT (
oi.id
)> 2
ORDER BY o.total desc
LIMIT 50;