lets say I hve the following in the 'fruits' table:
Round orange
Sunkist orange
navel orange
strawberry
blueberry
sunkist orange
apple
how would I get something like the following:
count as c | Fruit type
---------------------------------
4 | orange
2 | berry
1 | apple