Which of your Amazon SKUs are being returned the most?

SELECT
  i.sku,
  MAX(i.product_name)                                      AS product_name,
  COUNT(DISTINCT o.amazon_order_id)                        AS total_orders,
  COUNT(DISTINCT r.return_quantity)                        AS total_returns,
  ROUND(
    COUNT(DISTINCT r.return_quantity)::numeric * 100.0
    / NULLIF(COUNT(DISTINCT o.amazon_order_id), 0), 2
  )                                                        AS return_rate_pct
FROM amazon_order_items i
JOIN amazon_orders o
  ON o.amazon_order_id = i.amazon_order_id
LEFT JOIN amazon_returns r
  ON r.sku = i.sku
WHERE o.order_status NOT IN ('Canceled', 'Cancelled')
  AND i.item_price IS NOT NULL
  AND o.purchase_date::date >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY i.sku
HAVING COUNT(DISTINCT o.amazon_order_id) > 10
ORDER BY return_rate_pct DESC
LIMIT 25