CREATE TABLE medicine (id NUMBER, name CLOB, trade_name CLOB, fda_approved CLOB)
CREATE TABLE enzyme (id NUMBER, name CLOB, location CLOB, product CLOB, chromosome CLOB, omim NUMBER, porphyria CLOB)
CREATE TABLE medicine_enzyme_interaction (enzyme_id NUMBER, medicine_id NUMBER, interaction_type CLOB)

What are the ids, names, and FDA approval status for medicines ordered by descending number of possible enzyme interactions?
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
SELECT "T1"."id", "T1"."name", "T1"."fda_approved" FROM "medicine" "T1" JOIN "medicine_enzyme_interaction" "T2" ON "T1"."id" = "T2"."medicine_id" GROUP BY "T1"."id" ORDER BY COUNT(*) DESC