Hello, what are the names of the faculty members who don't participate in any activity?
select lname, fname from faculty except select facid from faculty_participates_in
Which faculty members participate in activities?
select t2.lname, t2.fname from faculty_participates_in as t1 join faculty as t2 on t1.facid = t2.facid
What activities do Michael Goodrich and Gerald Masson participate in?
select actid from faculty_participates_in as t1 join faculty as t2 on t1.facid = t2.facid where t2.lname = "Goodrich" and t2.fname = "Michael" union select actid from faculty_participates_in as t1 join faculty as t2 on t1.facid = t2.facid where t2.lname = "Masson" and t2.fname = "Gerald"
In total, how many faculty members are there?
select count ( * ) from faculty