ค้นหาชื่ออาจารย์ที่เข้าร่วมกิจกรรมพายเรือแคนูและพายเรือคายัค ไม่จำเป็นต้องใช้ทุกโต๊ะ
Find the first names of the faculty members who participate in Canoeing and Kayaking.It is not neccessary to use all the tables.
 participates_in:  stuid [ number]  actid [ number] 
SELECT T1.lname 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' INTERSECT SELECT T1.lname 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'