The Shipping Doubled

orders:

id cust shipping
1 A 10
2 B 20

order_items:

order_id qty price
1 1 100
1 2 50
2 1 30
SELECT o.cust,
       sum(o.shipping)        AS shipping,
       sum(i.qty * i.price)   AS goods
FROM orders o
JOIN order_items i ON i.order_id = o.id
GROUP BY o.cust;

What are the two rows?

A

A, 20, 300 and B, 20, 30

B

A, 20, 200 and B, 20, 30

C

A, 10, 200 and B, 20, 30

D

A, 10, 150 and B, 20, 30