What are the distinct name, location and products of the enzymes which has any 'inhibitor' interaction?
create table enzyme (name varchar, location varchar, product varchar, id varchar, PRIMARY KEY (name)); create table medicine_enzyme_interaction (enzyme_id varchar, interaction_type varchar, PRIMARY KEY (enzyme_id))
select distinct t1.name, t1.location, t1.product from enzyme as t1 join medicine_enzyme_interaction as t2 on t2.enzyme_id = t1.id where t2.interaction_type = 'inhibitor'