Can you draw a bar chart to show the number of positions of the pilots?, and I want to rank by the Y from low to high.
CREATE TABLE pilot_record (
    Record_ID int,
    Pilot_ID int,
    Aircraft_ID int,
    Date text
)

CREATE TABLE aircraft (
    Aircraft_ID int,
    Order_Year int,
    Manufacturer text,
    Model text,
    Fleet_Series text,
    Powertrain text,
    Fuel_Propulsion text
)

CREATE TABLE pilot (
    Pilot_ID int,
    Pilot_name text,
    Rank int,
    Age int,
    Nationality text,
    Position text,
    Join_Year int,
    Team text
)
SELECT Position, COUNT(Position) FROM pilot GROUP BY Position ORDER BY COUNT(Position)
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: Can you draw a bar chart to show the number of positions of the pilots?, and I want to rank by the Y from low to high. ### Input: CREATE TABLE pilot_record (
    Record_ID int,
    Pilot_ID int,
    Aircraft_ID int,
    Date text
)

CREATE TABLE aircraft (
    Aircraft_ID int,
    Order_Year int,
    Manufacturer text,
    Model text,
    Fleet_Series text,
    Powertrain text,
    Fuel_Propulsion text
)

CREATE TABLE pilot (
    Pilot_ID int,
    Pilot_name text,
    Rank int,
    Age int,
    Nationality text,
    Position text,
    Join_Year int,
    Team text
) ### Response: SELECT Position, COUNT(Position) FROM pilot GROUP BY Position ORDER BY COUNT(Position)