Show all female people from Canada.
select * from people where is_male = 'F' and country = 'Canada'
Show those that had a wedding in year 2016.
select * from wedding as t1 join people as t2 on t1.female_id = t2.people_id where t1.year = 2016 and t2.is_male = 'F' and t2.country = 'Canada'
What are their names?
select t2.name from wedding as t1 join people as t2 on t1.female_id = t2.people_id where t1.year = 2016 and t2.is_male = 'F' and t2.country = 'Canada'