Database: customers_campaigns_ecommerce
Question: Show all distinct product categories along with the number of mailshots in each category.
SQL:
SELECT product_category ,  count(*) FROM mailshot_campaigns GROUP BY product_category