CREATE TABLE pilot_record (Record_ID NUMBER, Pilot_ID NUMBER, Aircraft_ID NUMBER, Date CLOB)
CREATE TABLE aircraft (Aircraft_ID NUMBER, Order_Year NUMBER, Manufacturer CLOB, Model CLOB, Fleet_Series CLOB, Powertrain CLOB, Fuel_Propulsion CLOB)
CREATE TABLE pilot (Pilot_ID NUMBER, Pilot_name CLOB, Rank NUMBER, Age NUMBER, Nationality CLOB, Position CLOB, Join_Year NUMBER, Team CLOB)

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.
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")