By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| activity_date | userID | walking_value | swimming_value | running_value | cycling_value |
|---|---|---|---|---|---|
| 2023-03-11 | abc | null | null | null | 12 |
| 2023-03-12 | abc | 32 | null | null | null |
| 2023-03-12 | xyz | 45 | null | null | null |
| 2023-03-18 | xyz | null | 12 | null | null |
| 2023-03-19 | def | null | 33 | null | null |
| 2023-03-19 | xyz | null | null | null | 22 |
| 2023-03-20 | abc | null | null | 21 | null |
| 2023-03-25 | def | null | null | null | 54 |
Warning: Null value is eliminated by an aggregate or other SET operation.