CREATE TABLE enzyme (id NUMBER, name CLOB, location CLOB, product CLOB, chromosome CLOB, omim NUMBER, porphyria CLOB)
CREATE TABLE medicine (id NUMBER, name CLOB, trade_name CLOB, fda_approved CLOB)
CREATE TABLE medicine_enzyme_interaction (enzyme_id NUMBER, medicine_id NUMBER, interaction_type CLOB)

What are the ids and trade names of the medicine that can interact with at least 3 enzymes?
SELECT T1.id, T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id = T1.id GROUP BY T1.id HAVING COUNT(*) >= 3
SELECT "T1"."id", "T1"."trade_name" FROM "medicine" "T1" JOIN "medicine_enzyme_interaction" "T2" ON "T1"."id" = "T2"."medicine_id" GROUP BY "T1"."id" HAVING COUNT(*) >= 3