id | element
1 | a
2 | b
3 | c

...| element
...| a
...| a
...| c

element | count
a       | 2
b       | 0
c       | 1