By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
8.0.27 |
DATE | COUNT( DISTINCT id) |
---|---|
2022-05-21 | 1 |
2022-05-22 | 2 |
2022-05-23 | 2 |
2022-05-24 | 3 |
DATE | COUNT( DISTINCT id) |
---|---|
2022-05-21 | 1 |
2022-05-22 | 1 |
2022-05-24 | 1 |
DATE | C |
---|---|
2022-05-21 | 1 |
2022-05-22 | 1 |
2022-05-23 | 0 |
2022-05-24 | 1 |
DATE | id | id | C |
---|---|---|---|
2022-05-21 | 1 | null | 1 |
2022-05-22 | 1 | 1 | 0 |
2022-05-22 | 2 | null | 1 |
2022-05-23 | 1 | 1 | 0 |
2022-05-23 | 1 | 1 | 0 |
2022-05-23 | 2 | 2 | 0 |
2022-05-24 | 1 | 1 | 0 |
2022-05-24 | 1 | 1 | 0 |
2022-05-24 | 1 | 1 | 0 |
2022-05-24 | 2 | 2 | 0 |
2022-05-24 | 2 | 2 | 0 |
2022-05-24 | 3 | null | 1 |