Show the number of mailshot campaigns.
select count(*) from mailshot_campaigns
Breakdown the number by product category.
select product_category, count(*) from mailshot_campaigns group by product_category