By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ticket | total_ticket_payment | Payer1 | Payer2 | Payer3 | Payer4 |
|---|---|---|---|---|---|
| 100 | 320.0 | Insurance ABC | John Doe | null | null |
| 200 | 20.0 | John Doe | null | null | null |
Warning: Null value is eliminated by an aggregate or other SET operation.