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
### Context: CREATE TABLE medicine (trade_name VARCHAR) ### Question: find the number of medicines offered by each trade. ### Answer: SELECT trade_name, COUNT(*) FROM medicine GROUP BY trade_name