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
[{'Trade_Name': 'Abilify', 'count(*)': 1}, {'Trade_Name': 'Buronil', 'count(*)': 1}, {'Trade_Name': 'Clofekton', 'count(*)': 1}, {'Trade_Name': 'Clozaril', 'count(*)': 1}, {'Trade_Name': 'Cremin', 'count(*)': 1}, {'Trade_Name': 'Fanapt', 'count(*)': 1}, {'Trade_Name': 'Geodon', 'count(*)': 1}, {'Trade_Name': 'Invega', 'count(*)': 1}, {'Trade_Name': 'Latuda', 'count(*)': 1}, {'Trade_Name': 'Lonasen', 'count(*)': 1}, {'Trade_Name': 'Lullan', 'count(*)': 1}, {'Trade_Name': 'Nipolept', 'count(*)': 1}, {'Trade_Name': 'Prazinil', 'count(*)': 1}, {'Trade_Name': 'Risperdal', 'count(*)': 1}, {'Trade_Name': 'Roxiam', 'count(*)': 1}, {'Trade_Name': 'Saphris', 'count(*)': 1}, {'Trade_Name': 'Serdolect', 'count(*)': 1}, {'Trade_Name': 'Seroquel', 'count(*)': 1}, {'Trade_Name': 'Solian', 'count(*)': 1}, {'Trade_Name': 'Sulpirid', 'count(*)': 1}, {'Trade_Name': 'Zyprexa', 'count(*)': 1}]