Free Online SQL Query Formatter & Minifier

WITH
  monthly_sales AS (
    SELECT
      date_trunc('month', order_date) AS sales_month,
      customer_id,
      SUM(amount) AS total_revenue,
      COUNT(order_id) AS total_orders
    FROM
      orders
    WHERE
      status = 'completed'
      AND order_date >= NOW() - INTERVAL '1 year'
    GROUP BY
      1,
      2
  )
SELECT
  ms.sales_month,
  c.name,
  ms.total_revenue,
  RANK() OVER (
    PARTITION BY
      ms.sales_month
    ORDER BY
      ms.total_revenue DESC
  ) AS monthly_rank
FROM
  monthly_sales ms
  JOIN customers c ON ms.customer_id = c.id
WHERE
  ms.total_revenue > 1000
ORDER BY
  ms.sales_month DESC,
  monthly_rank ASC;