Database: activity_1
Question: Show all the activity names and the number of faculty involved in each activity.
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