For each faculty rank, show the number of faculty members who have it Show bar chart, and could you show total number from low to high order please?
CREATE TABLE Student (
    StuID INTEGER,
    LName VARCHAR(12),
    Fname VARCHAR(12),
    Age INTEGER,
    Sex VARCHAR(1),
    Major INTEGER,
    Advisor INTEGER,
    city_code VARCHAR(3)
)

CREATE TABLE Activity (
    actid INTEGER,
    activity_name varchar(25)
)

CREATE TABLE Faculty (
    FacID INTEGER,
    Lname VARCHAR(15),
    Fname VARCHAR(15),
    Rank VARCHAR(15),
    Sex VARCHAR(1),
    Phone INTEGER,
    Room VARCHAR(5),
    Building VARCHAR(13)
)

CREATE TABLE Faculty_Participates_in (
    FacID INTEGER,
    actid INTEGER
)

CREATE TABLE Participates_in (
    stuid INTEGER,
    actid INTEGER
)
SELECT Rank, COUNT(*) FROM Faculty GROUP BY Rank ORDER BY COUNT(*)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: For each faculty rank, show the number of faculty members who have it Show bar chart, and could you show total number from low to high order please? ### Input: CREATE TABLE Student (
    StuID INTEGER,
    LName VARCHAR(12),
    Fname VARCHAR(12),
    Age INTEGER,
    Sex VARCHAR(1),
    Major INTEGER,
    Advisor INTEGER,
    city_code VARCHAR(3)
)

CREATE TABLE Activity (
    actid INTEGER,
    activity_name varchar(25)
)

CREATE TABLE Faculty (
    FacID INTEGER,
    Lname VARCHAR(15),
    Fname VARCHAR(15),
    Rank VARCHAR(15),
    Sex VARCHAR(1),
    Phone INTEGER,
    Room VARCHAR(5),
    Building VARCHAR(13)
)

CREATE TABLE Faculty_Participates_in (
    FacID INTEGER,
    actid INTEGER
)

CREATE TABLE Participates_in (
    stuid INTEGER,
    actid INTEGER
) ### Response: SELECT Rank, COUNT(*) FROM Faculty GROUP BY Rank ORDER BY COUNT(*)