Can you tell me how many faculty are involved in each activity?
select t1.activity_name, count ( * ) from activity as t1 join faculty_participates_in as t2 on t1.actid = t2.actid group by t1.actid
What is the most popular activity?
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