human
Schema:
medicine (id, name, Trade_Name, FDA_approved)
enzyme (id, name, Location, Product, Chromosome, OMIM, Porphyria)
medicine_enzyme_interaction (enzyme_id, medicine_id, interaction_type)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the ids of enzymes that interact with at least one enzyme?
assistant
SELECT DISTINCT enzyme_id FROM medicine_enzyme_interaction;
human
Give their names, too.
assistant
SELECT T1.id , T1.Name FROM enzyme AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.enzyme_id = T1.id GROUP BY T1.id;
human
Which of those can interact as an 'activator'?
assistant
SELECT T1.id , T1.name FROM enzyme AS T1 JOIN medicine_enzyme_interaction AS T2 ON T1.id = T2.enzyme_id WHERE T2.interaction_type = "activitor" GROUP BY T1.id ;