By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| testdate | num |
|---|---|
| 2021-03-12 | 1 |
| 2021-03-15 | 1 |
| 2021-03-17 | 1 |
| 2021-03-18 | 1 |
| Date1 | coalesce(sum(t.num),0) |
|---|---|
| 2021-02-18 | 0 |
| 2021-02-19 | 0 |
| 2021-02-20 | 0 |
| 2021-02-21 | 0 |
| 2021-02-22 | 0 |
| 2021-02-23 | 0 |
| 2021-02-24 | 0 |
| 2021-02-25 | 0 |
| 2021-02-26 | 0 |
| 2021-02-27 | 0 |
| 2021-02-28 | 0 |
| 2021-03-01 | 0 |
| 2021-03-02 | 0 |
| 2021-03-03 | 0 |
| 2021-03-04 | 0 |
| 2021-03-05 | 0 |
| 2021-03-06 | 0 |
| 2021-03-07 | 0 |
| 2021-03-08 | 0 |
| 2021-03-09 | 0 |
| 2021-03-10 | 0 |
| 2021-03-11 | 0 |
| 2021-03-12 | 1 |
| 2021-03-13 | 0 |
| 2021-03-14 | 0 |
| 2021-03-15 | 1 |
| 2021-03-16 | 0 |
| 2021-03-17 | 1 |
| 2021-03-18 | 1 |
| 2021-03-19 | 0 |
| 2021-03-20 | 0 |
| 2021-03-21 | 0 |
| 2021-03-22 | 0 |
| 2021-03-23 | 0 |
| 2021-03-24 | 0 |
| 2021-03-25 | 0 |
| 2021-03-26 | 0 |
| 2021-03-27 | 0 |
| 2021-03-28 | 0 |
| 2021-03-29 | 0 |
| 2021-03-30 | 0 |
| 2021-03-31 | 0 |
| 2021-04-01 | 0 |
| 2021-04-02 | 0 |
| 2021-04-03 | 0 |
| 2021-04-04 | 0 |
| 2021-04-05 | 0 |
| 2021-04-06 | 0 |
| 2021-04-07 | 0 |
| 2021-04-08 | 0 |
| 2021-04-09 | 0 |
| 2021-04-10 | 0 |
| 2021-04-11 | 0 |
| 2021-04-12 | 0 |
| 2021-04-13 | 0 |
| 2021-04-14 | 0 |
| 2021-04-15 | 0 |
| 2021-04-16 | 0 |
| 2021-04-17 | 0 |
| 2021-04-18 | 0 |
| 2021-04-19 | 0 |
| 2021-04-20 | 0 |
| 2021-04-21 | 0 |
| 2021-04-22 | 0 |
| 2021-04-23 | 0 |
| 2021-04-24 | 0 |
| 2021-04-25 | 0 |
| 2021-04-26 | 0 |
| 2021-04-27 | 0 |
| 2021-04-28 | 0 |
| 2021-04-29 | 0 |
| 2021-04-30 | 0 |
| 2021-05-01 | 0 |
| 2021-05-02 | 0 |
| 2021-05-03 | 0 |
| 2021-05-04 | 0 |
| 2021-05-05 | 0 |
| 2021-05-06 | 0 |
| 2021-05-07 | 0 |
| 2021-05-08 | 0 |
| 2021-05-09 | 0 |
| 2021-05-10 | 0 |
| 2021-05-11 | 0 |
| 2021-05-12 | 0 |
| 2021-05-13 | 0 |
| 2021-05-14 | 0 |
| 2021-05-15 | 0 |
| 2021-05-16 | 0 |
| 2021-05-17 | 0 |
| 2021-05-18 | 0 |