Show the first names of the faculty members.
select fname from faculty
Which of them participate in canoeing?
select distinct t1.fname from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid join activity as t3 on t2.actid = t2.actid where t3.activity_name = 'Canoeing'
How about Kayaking?
select distinct t1.fname from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid join activity as t3 on t2.actid = t2.actid where t3.activity_name = 'Kayaking'
Show the first names for those participating in either of the two.
select distinct t1.fname from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid join activity as t3 on t2.actid = t2.actid where t3.activity_name = 'Canoeing' or t3.activity_name = 'Kayaking'