CREATE TABLE architect (id VARCHAR2, name VARCHAR2)
CREATE TABLE bridge (architect_id VARCHAR2)

What are the ids and names of the architects who built at least 3 bridges ?
SELECT T1.id, T1.name FROM architect AS T1 JOIN bridge AS T2 ON T1.id = T2.architect_id GROUP BY T1.id HAVING COUNT(*) >= 3
SELECT "T1"."id", "T1"."name" FROM "architect" "T1" JOIN "bridge" "T2" ON "T1"."id" = "T2"."architect_id" GROUP BY "T1"."id" HAVING COUNT(*) >= 3