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)

Can you draw a bar chart to show the number of positions of the pilots?, and I want to order bar in ascending order.
SELECT Position, COUNT(Position) FROM pilot GROUP BY Position ORDER BY Position
SELECT "Position", COUNT("Position") FROM "pilot" GROUP BY "Position" ORDER BY "Position" NULLS FIRST