CREATE TABLE Faculty (FacID INT, Lname VARCHAR, Fname VARCHAR, Rank VARCHAR, Sex VARCHAR, Phone INT, Room VARCHAR, Building VARCHAR)
CREATE TABLE Activity (actid INT, activity_name VARCHAR)
CREATE TABLE Faculty_Participates_in (FacID INT, actid INT)
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)

For each faculty rank, show the number of faculty members who have it Show bar chart, and could you order from low to high by the bar?
SELECT Rank, COUNT(*) FROM Faculty GROUP BY Rank ORDER BY Rank
SELECT "Rank", COUNT(*) FROM "Faculty" GROUP BY "Rank" ORDER BY "Rank" NULLS FIRST