Loading...
Pretty-print SQL — uppercases keywords and breaks SELECT / FROM / WHERE / JOIN clauses onto their own lines, in your browser.
A lightweight formatter — uppercases keywords and breaks major clauses onto their own lines. Best for SELECT/JOIN queries.
SELECT u.id, u.name, COUNT(o.id) AS orders FROM users u LEFT JOIN orders o ON o.user_id = u.id WHERE u.active = true AND o.total > 100 GROUP BY u.id, u.name ORDER BY orders DESC LIMIT 10;