Show the first and last name of all the faculty members.
select fname, lname from faculty
Which of those have participated in some activity?
select t1.fname, t1.lname from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid
For each of them, also show the number of activities they participated in.
select t1.fname, t1.lname, count(*) from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid group by t1.facid