Ah yes!  Can you please provide me with a list containing both?
select church_id, name from church
Thank you for that!  Could you filter that list to show only the  church names and ids of churches that have hosted 2 or more weddings?
select t1.name, t1.church_id from church as t1 join wedding as t2 on t1.church_id = t2.church_id group by t1.church_id having count ( * ) > = 2