Show the first name of faculty and their activity names.
select t1.fname, t3.activity_name from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid join activity as t3 on t2.actid = t2.actid
Which of them practice canoeing or 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 = 'Canoeing' or t3.activity_name = 'Kayaking'
Which of them do not?
select fname from faculty except 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'
Who among these are professors?
select fname from faculty where rank = 'Professor' except 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'