I have a table with a JSON field. The field contains one array of strings like:
["apple", "orange"]
["apple"]
["banana", "orange"]
["pineapple", "banana", "orange"]
How can I get the count of each of those value ? Like this :
orange, 3
apple, 2
banana, 2
pineapple, 1