By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
userid | license |
---|---|
1 | DOG |
1 | CAT |
1 | FISH |
2 | DOG |
2 | CAT |
3 | FISH |
4 | CAT |
4 | DOG |
4 | FISH |
5 | CAT |
5 | FISH |
USERID | LICENSE_COUNT |
---|---|
1 | 3 |
4 | 3 |
userid | license |
---|---|
1 | DOG |
1 | CAT |
1 | FISH |
2 | DOG |
2 | CAT |
3 | FISH |
4 | CAT |
4 | DOG |
4 | FISH |
5 | CAT |
5 | FISH |
USERID | LICENSE_COUNT |
---|---|
1 | 3 |
4 | 3 |