human
Schema:
medicine (id, name, Trade_Name, FDA_approved)
enzyme (id, name, Location, Product, Chromosome, OMIM, Porphyria)
medicine_enzyme_interaction (enzyme_id, medicine_id, interaction_type)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the id of the medicine 'Amisulpride'?
assistant
SELECT id FROM medicine WHERE name = 'Amisulpride';
human
What are the enzyme ids that interact as inhibitor with medicine 'Amisulpride'?
assistant
SELECT T2.enzyme_id FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T1.id = T2.medicine_id WHERE T1.name = "Amisulpride" AND T2.interaction_type = "inhibitor" ;