CREATE TABLE mailshot_campaigns (product_category VARCHAR2)

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"