Show all activity names.
select activity_name from activity
For each of them, also show the number of faculty members involved.
select t1.activity_name, count(*) from activity as t1 join faculty_participates_in as t2 on t1.actid = t2.actid group by t1.actid
Sort the names in the descending order of the faculty counts.
select t1.activity_name from activity as t1 join faculty_participates_in as t2 on t1.actid = t2.actid group by t1.actid order by count(*) desc
Which activity has the most?
select t1.activity_name from activity as t1 join faculty_participates_in as t2 on t1.actid = t2.actid group by t1.actid order by count(*) desc limit 1