Which medicine id can interact both as 'inhibitor' and as 'activitor'?
select medicine_id from medicine_enzyme_interaction where interaction_type = 'inhibitor' intersect select medicine_id from medicine_enzyme_interaction where interaction_type = 'activitor'
Give the medicine name and trade name for those.
select t1.name, t1.trade_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, t1.trade_name from medicine as t1 join medicine_enzyme_interaction as t2 on t2.medicine_id = t1.id where interaction_type = 'activitor'