Show me the medicine name which can interact as 'inhibitor'?
select t1.name from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id where interaction_type = 'inhibitor'
Show me the medicine name which can interact as 'activitor' with enzymes?
select t1.name from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id where interaction_type = 'activitor'
Show me the name of the medicines that are present in both the tables?
select t1.name from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id where interaction_type = 'inhibitor' intersect select t1.name from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id where interaction_type = 'activitor'