Show the first and last name for all faculty.
select fname, lname from faculty
For each of them, also count the number of activities they participate 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
Sort the names in the descending order of this count.
select t1.fname, t1.lname from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid group by t1.facid order by count(*) desc
Who participates in the most activities?
select t1.fname, t1.lname from faculty as t1 join faculty_participates_in as t2 on t1.facid = t2.facid group by t1.facid order by count(*) desc limit 1