By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
order_id | insurance | order_id | max(insurance.value) | group_concat(insurance.order_id) |
---|---|---|---|---|
100053000 | null | null | 9.5398 | 100053000 |
100053001 | 9.5398 | 100053000 | null | null |
100054000 | 2.9051 | 100054000 | 2.9051 | 100054000 |