SELECT
o.order_id,
c.customer_name,
c.email,
COUNT(oi.item_id) AS total_items,
SUM(oi.quantity * oi.unit_price) AS gross_revenue,
RANK() OVER(PARTITION BY c.region
ORDER BY SUM(oi.quantity * oi.unit_price) DESC) AS regional_rank
FROM orders o
INNER JOIN customers c ON o.customer_id = c.customer_id
LEFT JOIN order_items oi ON o.order_id = oi.order_id
WHERE o.order_status IN('completed',
'shipped')
AND o.created_at >= '2024-01-01'
GROUP BY o.order_id,
c.customer_name,
c.email,
c.region
HAVING SUM(oi.quantity * oi.unit_price) > 500
ORDER BY gross_revenue DESC
LIMIT 100;How to Format and Beautify SQL Queries
Transform cluttered, complex database code into clean, readable, standardized SQL in seconds.
1. Paste Your SQL Query
Enter your raw query into the input editor or pick from our presets covering multi-table JOINs, CTEs, and schema definitions.
2. Select Your Database Dialect
Choose your dialect (Standard ANSI, PostgreSQL, MySQL, SQLite, T-SQL, or Oracle) to ensure proper keyword and operator formatting.
3. Customize Style & Casing Options
Configure 2-space, 4-space, or tab indentation, uppercase or lowercase keywords (e.g. SELECT vs select), and comma placement.
4. Copy Beautified or Minified Code
Copy the formatted query directly to your database IDE, or switch to the Minified tab to get a compressed single-line string for logging or code.
Frequently Asked Questions about SQL Formatting
Properly indented and capitalized SQL drastically improves code review clarity, minimizes subtle logic errors in complex WHERE and JOIN conditions, and standardizes engineering team codebases across migrations and repositories.