By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
19 rows affected
COLUMN1 | ITEM_TO_COUNT | COUNT(*) |
---|---|---|
list1 | car | 2 |
list2 | toy | 1 |
list3 | toy | 1 |
list4 | cards | 2 |
list5 | toy | 2 |
list6 | cards | 2 |
19 rows affected
COLUMN1 | ITEM_TO_COUNT | COUNT(*) |
---|---|---|
list1 | car | 2 |
list2 | toy | 1 |
list3 | toy | 1 |
list4 | cards | 2 |
list5 | toy | 2 |
list6 | cards | 2 |