What are the ids, names and FDA approval status of medicines in descending order of the number of enzymes that it can interact with.
create table medicine_enzyme_interaction (medicine_id varchar, PRIMARY KEY (medicine_id)); create table medicine (id varchar, name varchar, fda_approved varchar, PRIMARY KEY (id))
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