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

Please compare the frequency of the position of the pilots using a bar chart, and could you order by the bars from high to low?
SELECT Position, COUNT(Position) FROM pilot GROUP BY Position ORDER BY Position DESC
SELECT "Position", COUNT("Position") FROM "pilot" GROUP BY "Position" ORDER BY "Position" DESC