By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| date_field | person |
|---|---|
| 2021-11-01 | Ivanov |
| 2021-11-01 | Ivanov |
| 2021-11-11 | Ivanov |
| 2021-11-01 | Petrov |
| 2021-11-01 | Petrov |
| 2021-11-11 | Sidorov |
| 2021-11-11 | Sidorov |
| 2021-11-15 | Ivanov |
| 2021-11-05 | Sidorov |
| cal_date | count(person) | person |
|---|---|---|
| 2021-11-01 | 2 | Ivanov |
| 2021-11-01 | 2 | Petrov |
| 2021-11-02 | 0 | null |
| 2021-11-03 | 0 | null |
| 2021-11-04 | 0 | null |
| 2021-11-05 | 1 | Sidorov |
| 2021-11-06 | 0 | null |
| 2021-11-07 | 0 | null |
| 2021-11-08 | 0 | null |
| 2021-11-09 | 0 | null |
| 2021-11-10 | 0 | null |
| 2021-11-11 | 1 | Ivanov |
| 2021-11-11 | 2 | Sidorov |
| 2021-11-12 | 0 | null |
| 2021-11-13 | 0 | null |
| 2021-11-14 | 0 | null |
| 2021-11-15 | 1 | Ivanov |
| 2021-11-16 | 0 | null |
| 2021-11-17 | 0 | null |
| 2021-11-18 | 0 | null |
| 2021-11-19 | 0 | null |
| 2021-11-20 | 0 | null |
| 2021-11-21 | 0 | null |
| 2021-11-22 | 0 | null |
| 2021-11-23 | 0 | null |
| 2021-11-24 | 0 | null |
| 2021-11-25 | 0 | null |
| 2021-11-26 | 0 | null |
| 2021-11-27 | 0 | null |
| 2021-11-28 | 0 | null |
| 2021-11-29 | 0 | null |
| 2021-11-30 | 0 | null |
| '2021-11-01' + INTERVAL seq DAY |
|---|
| 2021-11-01 |
| 2021-11-02 |
| 2021-11-03 |
| 2021-11-04 |
| 2021-11-05 |
| 2021-11-06 |
| 2021-11-07 |
| 2021-11-08 |
| 2021-11-09 |
| 2021-11-10 |
| 2021-11-11 |
| 2021-11-12 |
| 2021-11-13 |
| 2021-11-14 |
| 2021-11-15 |
| 2021-11-16 |
| 2021-11-17 |
| 2021-11-18 |
| 2021-11-19 |
| 2021-11-20 |
| 2021-11-21 |
| 2021-11-22 |
| 2021-11-23 |
| 2021-11-24 |
| 2021-11-25 |
| 2021-11-26 |
| 2021-11-27 |
| 2021-11-28 |
| 2021-11-29 |
| 2021-11-30 |
| cal_date | count(person) | person |
|---|---|---|
| 2021-11-01 | 2 | Ivanov |
| 2021-11-01 | 2 | Petrov |
| 2021-11-02 | 0 | null |
| 2021-11-03 | 0 | null |
| 2021-11-04 | 0 | null |
| 2021-11-05 | 1 | Sidorov |
| 2021-11-06 | 0 | null |
| 2021-11-07 | 0 | null |
| 2021-11-08 | 0 | null |
| 2021-11-09 | 0 | null |
| 2021-11-10 | 0 | null |
| 2021-11-11 | 1 | Ivanov |
| 2021-11-11 | 2 | Sidorov |
| 2021-11-12 | 0 | null |
| 2021-11-13 | 0 | null |
| 2021-11-14 | 0 | null |
| 2021-11-15 | 1 | Ivanov |
| 2021-11-16 | 0 | null |
| 2021-11-17 | 0 | null |
| 2021-11-18 | 0 | null |
| 2021-11-19 | 0 | null |
| 2021-11-20 | 0 | null |
| 2021-11-21 | 0 | null |
| 2021-11-22 | 0 | null |
| 2021-11-23 | 0 | null |
| 2021-11-24 | 0 | null |
| 2021-11-25 | 0 | null |
| 2021-11-26 | 0 | null |
| 2021-11-27 | 0 | null |
| 2021-11-28 | 0 | null |
| 2021-11-29 | 0 | null |
| 2021-11-30 | 0 | null |