By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| date | name | code |
|---|---|---|
| 2020-01-01 | category1 | 0 |
| 2020-01-02 | category1 | 1 |
| 2020-01-03 | category1 | 2 |
| 2020-01-04 | category1 | 3 |
| 2020-01-05 | category1 | 0 |
| 2020-01-06 | category1 | 1 |
| 2020-01-07 | category1 | 2 |
| 2020-01-08 | category1 | 0 |
| 2020-01-01 | category2 | 0 |
| 2020-01-02 | category2 | 0 |
| 2020-01-03 | category2 | 1 |
| 2020-01-04 | category2 | 0 |
| 2020-01-05 | category2 | 1 |
| 2020-01-06 | category2 | 2 |
| 2020-01-07 | category2 | 0 |
| 2020-01-08 | category2 | 1 |
| date | name | code |
|---|---|---|
| 2020-01-04 | category1 | 3 |
| 2020-01-07 | category1 | 2 |
| 2020-01-03 | category2 | 1 |
| 2020-01-06 | category2 | 2 |
| 2020-01-08 | category2 | 1 |