SQL Formatter

SELECT 
    u.id AS user_id,
    u.email,
    COUNT(o.id) AS total_orders,
    SUM(o.amount) AS total_spent
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.active = true AND o.created_at >= '2024-01-01'
GROUP BY u.id, u.email
HAVING COUNT(o.id) > 2
ORDER BY total_spent DESC
LIMIT 50;

SELECT 
    employee_id,
    department,
    salary,
    AVG(salary) OVER(PARTITION BY department) AS dept_avg_salary,
    RANK() OVER(PARTITION BY department ORDER BY salary DESC) AS salary_rank
FROM employees
WHERE active = true;

WITH MonthlySales AS (
    SELECT 
        DATE_TRUNC('month', created_at) AS sale_month,
        SUM(amount) AS monthly_revenue
    FROM sales
    GROUP BY 1
)
SELECT 
    sale_month,
    monthly_revenue,
    LAG(monthly_revenue) OVER(ORDER BY sale_month) AS prev_month_revenue
FROM MonthlySales;

INSERT INTO user_settings (user_id, theme, notifications_enabled, updated_at)
VALUES (42, 'dark', true, NOW())
ON CONFLICT (user_id) 
DO UPDATE SET 
    theme = EXCLUDED.theme,
    notifications_enabled = EXCLUDED.notifications_enabled,
    updated_at = NOW();