What are the ids of medicines that interact with at least one enzyme?
select distinct medicine_id from medicine_enzyme_interaction
Give their names, too.
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
Only show that information for medicines with at least two interactions.
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