Use `with paid as (select customer_id,sum(total) as amount from orders where status='paid' group by customer_id) select customer_id,amount from paid where amount>100 order by amount desc;` with PostgreSQL, two spaces, and uppercase keywords.

Expected layout

The result begins with `WITH paid AS (`. The nested SELECT list is placed on separate indented lines, followed by FROM, WHERE, and GROUP BY. The closing parenthesis is followed by the outer SELECT, whose two columns are split, then FROM, WHERE, and ORDER BY end with the original semicolon. The literal `'paid'`, identifiers, aliases, comparison value `100`, and DESC direction remain content; only layout and keyword case change.

Expected evidence

The evidence names PostgreSQL, shows the exact source and output character and line counts computed by the released formatter, and reports no comments before or after. Those counts help detect stale output but are not a query plan, row estimate, or validation result. The tool never knows whether orders, customer_id, total, or status exist.

Reproduce the exact fixture

Open SQLClear, load the example or paste the complete source exactly as printed, select the named dialect, two spaces, and uppercase keywords, then choose Format SQL. Compare every output line with the expected text before copying or downloading. Change the keyword case once and confirm that string values and quoted names remain unchanged. Clear the page and reload it: no query history should return. The example uses fictional catalog data, is never executed, and creates no request to a database or any other host.