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

How many students are advised by each rank of faculty? List the rank and the number of students Plot them as bar chart, I want to display from low to high by the Rank please.
SELECT Rank, COUNT(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.Advisor GROUP BY T1.Rank ORDER BY Rank
SELECT "Rank", COUNT(*) FROM "Faculty" AS "T1" JOIN "Student" AS "T2" ON "T1"."FacID" = "T2"."Advisor" GROUP BY "T1"."Rank" ORDER BY "Rank" NULLS FIRST