Stacked bar chart of the total number for with each Sex in each rank, and show names from low to high order please.
CREATE TABLE Participates_in (
    stuid INTEGER,
    actid INTEGER
)

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 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)
)
SELECT Rank, COUNT(*) FROM Faculty GROUP BY Sex, Rank ORDER BY Rank
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: Stacked bar chart of the total number for with each Sex in each rank, and show names from low to high order please. ### Input: CREATE TABLE Participates_in (
    stuid INTEGER,
    actid INTEGER
)

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 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)
) ### Response: SELECT Rank, COUNT(*) FROM Faculty GROUP BY Sex, Rank ORDER BY Rank