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

Show me a bar chart for how many students are advised by each rank of faculty? List the rank and the number of students, and order in ascending by the Y-axis please.
SELECT Rank, COUNT(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID = T2.Advisor GROUP BY T1.Rank ORDER BY COUNT(*)
SELECT "Rank", COUNT(*) FROM "Faculty" "T1" JOIN "Student" "T2" ON "T1"."FacID" = "T2"."Advisor" GROUP BY "T1"."Rank" ORDER BY COUNT(*)