By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | userID | title | data |
---|---|---|---|
1 | 1 | DATE | 01-01-2021 |
2 | 1 | COLOR | RED |
3 | 2 | DATE | null |
4 | 2 | COLOR | YELLOW |
5 | 3 | DATE | 04-01-2021 |
6 | 3 | COLOR | RED |
5 | 4 | DATE | 04-01-2021 |
6 | 4 | COLOR | PINK |
7 | 5 | DATE | 02-01-2021 |
8 | 5 | COLOR | PINK |
7 | 6 | DATE | 08-01-2021 |
8 | 6 | COLOR | PINK |
Color | PickedUp | Total |
---|---|---|
RED | 2 | 2 |
YELLOW | 0 | 1 |
PINK | 3 | 3 |