What is the total number of captains in each rank and class? Let class as X-axis, and categorize by rank with a stacked bar chart, rank by the X-axis in ascending.
CREATE TABLE captain (
    Captain_ID int,
    Name text,
    Ship_ID int,
    age text,
    Class text,
    Rank text
)

CREATE TABLE Ship (
    Ship_ID int,
    Name text,
    Type text,
    Built_Year real,
    Class text,
    Flag text
)
SELECT Class, COUNT(Class) FROM captain GROUP BY Rank, Class ORDER BY Class
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: What is the total number of captains in each rank and class? Let class as X-axis, and categorize by rank with a stacked bar chart, rank by the X-axis in ascending. ### Input: CREATE TABLE captain (
    Captain_ID int,
    Name text,
    Ship_ID int,
    age text,
    Class text,
    Rank text
)

CREATE TABLE Ship (
    Ship_ID int,
    Name text,
    Type text,
    Built_Year real,
    Class text,
    Flag text
) ### Response: SELECT Class, COUNT(Class) FROM captain GROUP BY Rank, Class ORDER BY Class