Task: Text to Code
Input (English): How many medicines are offered by each trade name?
Output (English): SELECT trade_name ,  count(*) FROM medicine GROUP BY trade_name