SELECT trade_name ,  count(*) FROM medicine GROUP BY trade_name
How many medicines are offered by each trade name?
SELECT trade_name , count ( * ) FROM medicine GROUP BY trade_name
select trade_name , count ( * ) from medicine group by trade_name
How many medicines are offered by each trade name ?