What're the names of the enzymes in the medicine "Amisulpride"?
select t1.name from enzyme as t1 join medicine_enzyme_interaction as t2 on t1.id = t2.enzyme_id join medicine as t3 on t2.medicine_id = t3.id where t3.name = 'Amisulpride'
What're the names of the enzymes in the medicine "Amisulpride" that can serve as an inhibitor?
select t1.name from enzyme as t1 join medicine_enzyme_interaction as t2 on t1.id = t2.enzyme_id join medicine as t3 on t2.medicine_id = t3.id where t3.name = 'Amisulpride' and t2.interaction_type = 'inhibitor'
What are the names of all enzymes that can serve as inhibitors?
select distinct ( t1.name ) from enzyme as t1 join medicine_enzyme_interaction as t2 on t1.id = t2.enzyme_id join medicine as t3 on t2.medicine_id = t3.id where t2.interaction_type = 'inhibitor'