Which weddings took place after 2014?
select * from wedding where year > 2014
What are the male names in weddings after 2014?
select t2.name from wedding as t1 join people as t2 on t1.male_id = t2.people_id where t1.year > 2014
What are the female names in weddings after 2014?
select t3.name from wedding as t1 join people as t2 on t1.male_id = t2.people_id join people as t3 on t1.female_id = t3.people_id where t1.year > 2014