By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 1 Duplicates: 0 Warnings: 0
| dte | count(t.id) |
|---|---|
| 2021-08-01 | 0 |
| 2021-08-02 | 0 |
| 2021-08-03 | 1 |
| 2021-08-04 | 1 |
| 2021-08-05 | 1 |
| 2021-08-06 | 1 |
| 2021-08-07 | 1 |
| 2021-08-08 | 0 |
| 2021-08-09 | 0 |
| 2021-08-10 | 0 |