Relational joins

SELECT s.business_key, c.charge_code, c.sell_local_amount
FROM reporting.shipments AS s
JOIN reporting.shipment_charges AS c
  ON c.shipment_id = s.shipment_id
ORDER BY s.business_key
LIMIT 100;

WITH charges AS (
  SELECT shipment_id, SUM(sell_local_amount) AS charge_total
  FROM reporting.shipment_charges
  GROUP BY shipment_id
)
SELECT s.business_key, s.total_revenue, c.charge_total
FROM reporting.shipments AS s
LEFT JOIN charges AS c
  ON c.shipment_id = s.shipment_id;