Show me the total number of the flag of ships that are not steered by any captain with Midshipman rank using a bar graph, and I want to rank total number in asc order please.
CREATE TABLE Ship (
    Ship_ID int,
    Name text,
    Type text,
    Built_Year real,
    Class text,
    Flag text
)

CREATE TABLE captain (
    Captain_ID int,
    Name text,
    Ship_ID int,
    age text,
    Class text,
    Rank text
)
SELECT Flag, COUNT(Flag) FROM Ship WHERE NOT Ship_ID IN (SELECT Ship_ID FROM captain WHERE Rank = 'Midshipman') GROUP BY Flag ORDER BY COUNT(Flag)
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: Show me the total number of the flag of ships that are not steered by any captain with Midshipman rank using a bar graph, and I want to rank total number in asc order please. ### Input: CREATE TABLE Ship (
    Ship_ID int,
    Name text,
    Type text,
    Built_Year real,
    Class text,
    Flag text
)

CREATE TABLE captain (
    Captain_ID int,
    Name text,
    Ship_ID int,
    age text,
    Class text,
    Rank text
) ### Response: SELECT Flag, COUNT(Flag) FROM Ship WHERE NOT Ship_ID IN (SELECT Ship_ID FROM captain WHERE Rank = 'Midshipman') GROUP BY Flag ORDER BY COUNT(Flag)