Show the information about weddings after year 2014.
select * from wedding where year > 2014
Show the male names in all 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
Show the pair of male and female names in all weddings after year 2014.
select t2.name, 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