How many medicines are offered by each trade name?
SELECT trade_name ,  count(*) FROM medicine GROUP BY trade_name
number of medicines offered refers to COUNT(*); by each trade name refers to GROUP BY trade_name;