Database: activity_1
Question: How many faculty members participate in each activity? Return the activity names and the number of faculty members.
SQL:
SELECT T1.activity_name ,  count(*) FROM Activity AS T1 JOIN Faculty_participates_in AS T2 ON T1.actID  =  T2.actID GROUP BY T1.actID