Which US states generate the most revenue from your Amazon store?

SELECT
  o.ship_state                                   AS state,
  COUNT(DISTINCT o.amazon_order_id)             AS orders,
  SUM(i.quantity)                               AS units_sold,
  ROUND(SUM(i.item_price * i.quantity)::numeric, 2) AS gross_revenue,
  ROUND(AVG(i.item_price * i.quantity)::numeric, 2) AS avg_order_value,
  ROUND(SUM(i.item_price * i.quantity)::numeric * 100
    / NULLIF(SUM(SUM(i.item_price * i.quantity)) OVER ()::numeric, 0), 1) AS pct_of_total
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.ship_state IS NOT NULL
  AND o.ship_state != ''
  AND o.purchase_date::date >= NOW() - INTERVAL '12 months'
GROUP BY o.ship_state
ORDER BY gross_revenue DESC
LIMIT 25