Show all distinct product categories along with the number of mailshots in each category.
SELECT product_category ,  count(*) FROM mailshot_campaigns GROUP BY product_category
SELECT product_category ,  count(*) FROM mailshot_campaigns GROUP BY product_category
[{'product_category': 'clothes', 'count(*)': 9}, {'product_category': 'food', 'count(*)': 11}]