CREATE TABLE Faculty_participates_in (actID VARCHAR)
CREATE TABLE Activity (activity_name VARCHAR, actID VARCHAR)

Show all the activity names and the number of faculty 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
SELECT "T1"."activity_name", COUNT(*) FROM "Activity" AS "T1" JOIN "Faculty_participates_in" AS "T2" ON "T1"."actID" = "T2"."actID" GROUP BY "T1"."actID"