CREATE TABLE Participates_in (stuid INT, actid INT)
CREATE TABLE Faculty_Participates_in (FacID INT, actid INT)
CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)
CREATE TABLE Activity (actid INT, activity_name VARCHAR)
CREATE TABLE Faculty (FacID INT, Lname VARCHAR, Fname VARCHAR, Rank VARCHAR, Sex VARCHAR, Phone INT, Room VARCHAR, Building VARCHAR)

A bar chart showing the first name of all the faculty members who participated in some activity, together with the number of activities they participated in.
SELECT Fname, COUNT(*) FROM Faculty AS T1 JOIN Faculty_Participates_in AS T2 ON T1.FacID = T2.FacID GROUP BY T1.FacID
SELECT "Fname", COUNT(*) FROM "Faculty" AS "T1" JOIN "Faculty_Participates_in" AS "T2" ON "T1"."FacID" = "T2"."FacID" GROUP BY "T1"."FacID"