SQL Formatter | Useful Online Tools

Source Query

Raw SQL Statement

SQL Query

Keyword case

Indentation

Comma placement

Formatted Output

Beautified SQL

Output

WITH
  regional_sales AS (
    SELECT
      o.region_id,
      SUM(oi.quantity * oi.unit_price) AS total_revenue,
      COUNT(DISTINCT o.customer_id) AS unique_buyers
    FROM
      orders o
    INNER JOIN
      order_items oi
      ON oi.order_id = o.id
    WHERE
      o.status = 'completed'
      AND o.created_at >= :start_date
    GROUP BY
      o.region_id
)
SELECT
  r.name AS region_name,
  rs.total_revenue,
  rs.unique_buyers,
  ROUND(rs.total_revenue / NULLIF(rs.unique_buyers,  0),  2) AS avg_revenue_per_buyer
FROM
  regional_sales rs
LEFT JOIN
  regions r
  ON r.id = rs.region_id
WHERE
  rs.total_revenue > 25000
HAVING
  rs.unique_buyers >= 10
ORDER BY
  rs.total_revenue DESC,
  r.name ASC
LIMIT
  25
OFFSET
  0;

Query Structure

SQL Statement Metrics

14 Major SQL clauses

2 JOIN operations

1 Bound parameters

38 Output lines

Related in Developer & Data

More tools in this category

View all tools →

Regex Checker

Test and debug regular expressions in real time with match highlights, capture groups, and flags.

Diff Checker

Compare two text blocks side-by-side or inline to highlight exact insertions and deletions.

JSON Formatter

Beautify, validate, and minify JSON data with recursive key sorting and line-level error detection.

CSV ↔ JSON

Convert between CSV and JSON formats with support for quoted fields, custom delimiters, and headers.