SQL-форматтер

Расставляет переносы и отступы в SQL-запросе, делает ключевые слова заглавными.

Входные данные

Открыть файл

select u.id, u.email, count(o.id) as orders, sum(o.total) as spent from users u left join orders o on o.user_id = u.id and o.status = 'paid' where u.created_at between '2026-01-01' and '2026-11-01' and u.plan in ('pro', 'studio') and exists (select 1 from sessions s where s.user_id = u.id) group by u.id, u.email having count(o.id) > 2 order by spent desc limit 50;

Результат

SELECT
  u.id,
  u.email,
  COUNT(o.id) AS orders,
  SUM(o.total) AS spent
FROM users u
LEFT JOIN orders o
  ON o.user_id = u.id
  AND o.status = 'paid'
WHERE u.created_at BETWEEN '2026-01-01' AND '2026-11-01'
  AND u.plan IN ('pro', 'studio')
  AND EXISTS (
    SELECT
      1
    FROM sessions s
    WHERE s.user_id = u.id
  )
GROUP BY
  u.id,
  u.email
HAVING COUNT(o.id) > 2
ORDER BY
  spent DESC
LIMIT 50;

SQL-форматтер

Входные данные

Результат

Другие инструменты