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

Can you draw a bar chart to show the number of positions of the pilots?, rank in descending by the total number please.
SELECT Position, COUNT(Position) FROM pilot GROUP BY Position ORDER BY COUNT(Position) DESC
SELECT "Position", COUNT("Position") FROM "pilot" GROUP BY "Position" ORDER BY COUNT("Position") DESC NULLS LAST