Show all distinct product categories along with the number of mailshots in each category.
CREATE TABLE mailshot_campaigns (product_category VARCHAR)
SELECT product_category, COUNT(*) FROM mailshot_campaigns GROUP BY product_category
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE mailshot_campaigns (product_category VARCHAR) Question: Show all distinct product categories along with the number of mailshots in each category. [/INST] SELECT product_category, COUNT(*) FROM mailshot_campaigns GROUP BY product_category </s>