How much are FBA fees actually costing you — per SKU?

SELECT
  f.sku,
  ROUND(SUM(CASE WHEN f.fee_type ILIKE '%referral%'     THEN f.fee_amount ELSE 0 END)::numeric, 2) AS referral_fees,
  ROUND(SUM(CASE WHEN f.fee_type ILIKE '%fulfillment%'  THEN f.fee_amount ELSE 0 END)::numeric, 2) AS fulfillment_fees,
  ROUND(SUM(CASE WHEN f.fee_type ILIKE '%storage%'      THEN f.fee_amount ELSE 0 END)::numeric, 2) AS storage_fees,
  ROUND(SUM(f.fee_amount)::numeric, 2)                                                              AS total_fees,
  ROUND(SUM(i.item_price * i.quantity)::numeric, 2)                                                AS gross_revenue,
  ROUND(
    SUM(i.item_price * i.quantity)::numeric - SUM(f.fee_amount)::numeric
  , 2)                                                                                              AS net_revenue,
  ROUND(
    (SUM(i.item_price * i.quantity)::numeric - SUM(f.fee_amount)::numeric)
    / NULLIF(SUM(i.item_price * i.quantity)::numeric, 0) * 100
  , 1)                                                                                              AS net_margin_pct
FROM amazon_fba_fees f
LEFT JOIN amazon_order_items i ON i.sku = f.sku
LEFT JOIN amazon_orders o ON o.amazon_order_id = i.amazon_order_id
  AND o.purchase_date::date >= DATE_TRUNC('quarter', CURRENT_DATE)
  AND o.order_status NOT IN ('Canceled', 'Cancelled')
WHERE f.sku IS NOT NULL
GROUP BY f.sku
ORDER BY total_fees DESC