Task: Text to Code
Input (English): SQL: SELECT id , name , Porphyria FROM enzyme ORDER BY Porphyria Desc
Feedback: Find id , name and fda approved of medicine table ordered descending by medicine id , Ensure that fda approved equals Yes .
Output (English): 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