CREATE TABLE medicine (trade_name VARCHAR)

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"