By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| campaign | process_status | delivery_type | SUM(l2.quantity) |
|---|---|---|---|
| C001 | offer | fedex | 700 |
| C001 | order | ubs | 400 |
| C001 | shipped | ubs | 100 |
| C003 | offer | fedex | 730 |
| C003 | order | fedex | 620 |
| C003 | shipped | dhl | 530 |
| C005 | order | fedex | 900 |
| C005 | shipped | ubs | 475 |