Which Shopify products are being refunded the most?

WITH product_orders AS (
  SELECT
    li.product_id,
    li.title                         AS product_name,
    SUM(li.quantity)                 AS units_sold,
    ROUND(SUM(li.price * li.quantity)::numeric, 2) AS revenue
  FROM shopify_order_line_items li
  JOIN shopify_orders o ON o.id = li.order_id
  WHERE o.financial_status IN ('paid', 'partially_refunded', 'refunded')
    AND o.created_at >= NOW() - INTERVAL '90 days'
  GROUP BY li.product_id, li.title
),
product_refunds AS (
  SELECT
    li.product_id,
    SUM(li.quantity)                 AS units_refunded,
    ROUND(SUM(li.price * li.quantity)::numeric, 2) AS refund_amount
  FROM shopify_refunds r
  JOIN shopify_order_line_items li ON li.order_id = r.order_id
  WHERE r.created_at >= NOW() - INTERVAL '90 days'
  GROUP BY li.product_id
)
SELECT
  po.product_name,
  po.units_sold,
  COALESCE(pr.units_refunded, 0)   AS units_refunded,
  po.revenue,
  COALESCE(pr.refund_amount, 0)    AS refund_amount,
  ROUND(
    COALESCE(pr.units_refunded, 0)::numeric * 100
    / NULLIF(po.units_sold, 0), 2
  )                                AS refund_rate_pct
FROM product_orders po
LEFT JOIN product_refunds pr USING (product_id)
WHERE po.units_sold >= 10
ORDER BY refund_rate_pct DESC
LIMIT 25