Show the id, name, and FDA approval for medicines.
select id, name, fda_approved from medicine
Only ones that have some interaction with an enzyme.
select id, name, fda_approved from medicine where id in (select medicine_id from medicine_enzyme_interaction)
Order that by descending order of number of enzymes the medicine interacts with.
select t1.id, t1.name, t1.fda_approved from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id group by t1.id order by count(*) desc