DevTools Studio
Home
Tools
Docs
Changelog
About
Toggle theme
DevTools Studio
Toggle theme
Home
Tools
Docs
Changelog
About
Tools
/
SQL Formatter
SQL Formatter & Beautifier
Format, indent, standardize keywords, or minify raw SQL queries.
Uppercase Keywords: ON
Raw SQL Input
Clear
SELECT u.id, u.email, u.name, r.key as role_key, count(o.id) as order_count, sum(o.gross_sales) as total_revenue FROM core_users u LEFT JOIN core_user_roles ur ON u.id = ur.user_id LEFT JOIN core_roles r ON ur.role_id = r.id LEFT JOIN pos_orders o ON u.id = o.user_id WHERE u.is_active = true AND u.tenant_id = 'a07e1c14-6160-4ff9-9407-1593893f8724' GROUP BY u.id, u.email, u.name, r.key HAVING count(o.id) > 0 ORDER BY total_revenue DESC LIMIT 20;
448 chars
Minify
Format SQL
Formatted Output
Copy
1 lines · 0 characters