CREATE TABLE wedding (church_id VARCHAR2)
CREATE TABLE church (name VARCHAR2, church_id VARCHAR2)

Show all church names that have hosted least two weddings.
SELECT T1.name FROM church AS T1 JOIN wedding AS T2 ON T1.church_id = T2.church_id GROUP BY T1.church_id HAVING COUNT(*) >= 2
SELECT "T1"."name" FROM "church" "T1" JOIN "wedding" "T2" ON "T1"."church_id" = "T2"."church_id" GROUP BY "T1"."church_id" HAVING COUNT(*) >= 2