-- Database schema
| medicine : id [ INT ] primary_key , name [ TEXT ] , Trade_Name [ TEXT ] , FDA_approved [ TEXT ] | enzyme : id [ INT ] primary_key , name [ TEXT ] , Location [ TEXT ] , Product [ TEXT ] , Chromosome [ TEXT ] , OMIM [ INT ] , Porphyria [ TEXT ] | medicine_enzyme_interaction : enzyme_id [ INT ] primary_key medicine_enzyme_interaction.enzyme_id = enzyme.id , medicine_id [ INT ] medicine_enzyme_interaction.medicine_id = medicine.id , interaction_type [ TEXT ] |
-- -- What is the interaction type of the enzyme named 'ALA synthase' and the medicine named 'Aripiprazole'?

SELECT T1.interaction_type 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 T3.name  =  'ALA synthase' AND T2.name  =  'Aripiprazole';