Group all the medications by the brand.
select * from medication group by brand
How many medications are prescribed for each brand?
select count(*), t1.name from medication as t1 join prescribes as t2 on t1.code = t2.medication group by t1.brand