What is the enzyme id of 'ALA synthase'?
select id from enzyme where name = 'ALA synthase'
How about for the medicine named 'Aripiprazole'?
select id from medicine where name = 'Aripiprazole'
Show where those two ids index into the interaction table together.
select * from medicine_enzyme_interaction as t1 join medicine as t2 on t1.medicine_id = t2.id join enzyme as t3 on t1.enzyme_id = t3.id where t3.name = 'ALA synthase' and t2.name = 'Aripiprazole'
Just give the interaction type for that entry.
select t1.interaction_type from medicine_enzyme_interaction as t1 join medicine as t2 on t1.medicine_id = t2.id join enzyme as t3 on t1.enzyme_id = t3.id where t3.name = 'ALA synthase' and t2.name = 'Aripiprazole'