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

A pie chart showing the number of faculty members for each rank.
SELECT Rank, COUNT(Rank) FROM Faculty GROUP BY Rank
SELECT "Rank", COUNT("Rank") FROM "Faculty" GROUP BY "Rank"