Find all types of store and number of them.
SELECT TYPE ,  count(*) FROM store GROUP BY TYPE
SELECT TYPE ,  count(*) FROM store GROUP BY TYPE
[{'Type': 'City Mall', 'count(*)': 2}, {'Type': 'Village Store', 'count(*)': 3}]