How is your Amazon revenue trending month by month?

SELECT
  TO_CHAR(DATE_TRUNC('month', o.purchase_date::timestamptz), 'YYYY-MM') AS order_month,
  COUNT(DISTINCT o.amazon_order_id)                                       AS total_orders,
  SUM(i.quantity)                                                         AS units_sold,
  ROUND(SUM(i.item_price * i.quantity), 2)                                AS gross_revenue,
  ROUND(SUM(i.item_price * i.quantity)
    / NULLIF(COUNT(DISTINCT o.amazon_order_id), 0), 2)                  AS avg_order_value
FROM amazon_orders o
JOIN amazon_order_items i
  ON i.amazon_order_id = o.amazon_order_id
WHERE o.order_status NOT IN ('Canceled', 'Cancelled')
  AND i.item_price IS NOT NULL
  AND o.purchase_date::timestamptz >= NOW() - INTERVAL '12 months'
GROUP BY DATE_TRUNC('month', o.purchase_date::timestamptz)
ORDER BY 1 ASC