CREATE TABLE medicine (trade_name VARCHAR(255))
find the number of medicines offered by each trade.
    
SQL: SELECT trade_name, COUNT(*) FROM medicine GROUP BY trade_name