What are the ids and names of the medicine that can interact with two or more enzymes?
select t1.id, t1.name from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id group by t1.id having count ( * ) > = 2
How many enzymes can Aripiprazole interact with?
select count ( distinct t2.enzyme_id ) from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id where name = "Aripiprazole"
* I have left the chat *
select count ( distinct t2.enzyme_id ) from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id where name = "Asenapine"