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
How many kinds of enzymes are there?
assistant
SELECT count(*) FROM enzyme
human
Which enzyme names have the substring 'ALA'?
assistant
SELECT name FROM enzyme WHERE name LIKE '%ALA%'
human
List the name of enzymes in descending lexicographical order.
assistant
SELECT name FROM enzyme ORDER BY name DESC
human
What are the distinct name, location and products of the enzymes which has any 'inhibitor' interaction?
assistant
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'
human
Show the medicine names and trade names that cannot interact with the enzyme with product 'Heme'.
assistant
SELECT name , trade_name FROM medicine EXCEPT SELECT T1.name , T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id = T1.id JOIN enzyme AS T3 ON T3.id = T2.enzyme_id WHERE T3.product = 'Protoporphyrinogen IX'
human
What are the names of enzymes whose product is not 'Heme'?
assistant
SELECT name FROM enzyme WHERE product != "Heme" ;