SELECT trade_name ,  count(*) FROM medicine GROUP BY trade_name
find the number of medicines offered by each trade.
SELECT trade_name , count ( * ) FROM medicine GROUP BY trade_name
select trade_name , count ( * ) from medicine group by trade_name
find the number of medicines offered by each trade .