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)
CREATE TABLE pilot_record (Record_ID INT, Pilot_ID INT, Aircraft_ID INT, Date TEXT)

Bar chart of the number of position from each position, and could you sort the number of position in asc order please?
SELECT Position, COUNT(Position) FROM pilot GROUP BY Position ORDER BY COUNT(Position)
SELECT "Position", COUNT("Position") FROM "pilot" GROUP BY "Position" ORDER BY COUNT("Position") NULLS FIRST