SELECT Position, COUNT(Position) FROM pilot GROUP BY Position
Bar chart of the number of position from each position
CREATE TABLE pilot_record (
    Record_ID int,
    Pilot_ID int,
    Aircraft_ID int,
    Date text
)

CREATE TABLE pilot (
    Pilot_ID int,
    Pilot_name text,
    Rank int,
    Age int,
    Nationality text,
    Position text,
    Join_Year int,
    Team text
)

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