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
can you tell me all the enzymes that work in the cytosol?
assistant
SELECT name FROM enzyme WHERE location = 'Cytosol';
human
which of those enzymes is in the medicine with the name Aripiprazole?
assistant
SELECT T3.name FROM medicine_enzyme_interaction AS T1 JOIN medicine AS T2 ON T1.medicine_id = T2.id JOIN enzyme AS T3 ON T1.enzyme_id = T3.id WHERE T2.name = "Aripiprazole" AND T3.location = "Cytosol" ;