How is your Shopify revenue trending month over month?

SELECT
  TO_CHAR(DATE_TRUNC('month', o.created_at), 'YYYY-MM')  AS order_month,
  COUNT(DISTINCT o.id)                                    AS orders,
  COUNT(DISTINCT o.customer_id)                          AS unique_customers,
  ROUND(SUM(o.total_price)::numeric, 2)                  AS gross_revenue,
  ROUND(SUM(o.total_price)::numeric
    / NULLIF(COUNT(DISTINCT o.id), 0), 2)                AS avg_order_value,
  ROUND(SUM(o.total_price - o.total_refunded)::numeric, 2) AS net_revenue
FROM shopify_orders o
WHERE o.financial_status IN ('paid', 'partially_refunded')
  AND o.created_at >= NOW() - INTERVAL '12 months'
GROUP BY DATE_TRUNC('month', o.created_at)
ORDER BY 1 ASC