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

How many faculty members do we have for each faculty rank Show bar chart, display in asc by the bars.
SELECT Rank, COUNT(*) FROM Faculty GROUP BY Rank ORDER BY Rank
SELECT "Rank", COUNT(*) FROM "Faculty" GROUP BY "Rank" ORDER BY "Rank" NULLS FIRST