By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| name | date | happiness |
|---|---|---|
| John | 03/01/2020 00:00:00 | 20 |
| John | 04/01/2020 00:00:00 | null |
| John | 05/01/2020 00:00:00 | null |
| John | 06/01/2020 00:00:00 | null |
| John | 07/01/2020 00:00:00 | 18 |
| Mary | 01/01/2020 00:00:00 | 35 |
| Mary | 02/01/2020 00:00:00 | null |
| Mary | 03/01/2020 00:00:00 | -15 |
| Mary | 04/01/2020 00:00:00 | null |
| Mary | 05/01/2020 00:00:00 | 0 |
| name | date | happiness |
|---|---|---|
| John | 03/01/2020 00:00:00 | 20 |
| John | 04/01/2020 00:00:00 | 20 |
| John | 05/01/2020 00:00:00 | 20 |
| John | 06/01/2020 00:00:00 | 20 |
| John | 07/01/2020 00:00:00 | 18 |
| Mary | 01/01/2020 00:00:00 | 35 |
| Mary | 02/01/2020 00:00:00 | 35 |
| Mary | 03/01/2020 00:00:00 | -15 |
| Mary | 04/01/2020 00:00:00 | -15 |
| Mary | 05/01/2020 00:00:00 | 0 |