find the number of medicines offered by each trade.
CREATE TABLE medicine (trade_name VARCHAR)
SELECT trade_name, COUNT(*) FROM medicine GROUP BY trade_name
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE medicine (trade_name VARCHAR) Question: find the number of medicines offered by each trade. [/INST] SELECT trade_name, COUNT(*) FROM medicine GROUP BY trade_name </s>