Task: Text to Code
Input (English): Step 1: For each row in medicine_enzyme_interaction table, find corresponding rows in medicine table and in enzyme table.
Step 2: find Trade_Name, medicine's name of the results of step 1 whose Porphyria equals inhibitor.
Step 3: find Trade_Name, medicine's name of the results of step 1 whose Porphyria equals activitor.
Step 4: show the rows that are in both the results of step 2 and the results of step 3
Output (English): SELECT T1.Trade_Name , T1.name FROM medicine AS T1 JOIN enzyme AS T2 JOIN medicine_enzyme_interaction AS T3 ON T1.id = T3.medicine_id AND T3.enzyme_id = T2.id WHERE T2.Porphyria = "inhibitor" INTERSECT SELECT T1.Trade_Name , T1.name FROM medicine AS T1 JOIN enzyme AS T2 JOIN medicine_enzyme_interaction AS T3 ON T1.id = T3.medicine_id AND T3.enzyme_id = T2.id WHERE T2.Porphyria = "activitor"