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

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" "T1" JOIN "Faculty_participates_in" "T2" ON "T1"."actID" = "T2"."actID" GROUP BY "T1"."actID"