CREATE TABLE pilot_record (Record_ID NUMBER, Pilot_ID NUMBER, Aircraft_ID NUMBER, Date 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 aircraft (Aircraft_ID NUMBER, Order_Year NUMBER, Manufacturer CLOB, Model CLOB, Fleet_Series CLOB, Powertrain CLOB, Fuel_Propulsion CLOB)

Bar chart of the number of position from each position
SELECT Position, COUNT(Position) FROM pilot GROUP BY Position
SELECT "Position", COUNT("Position") FROM "pilot" GROUP BY "Position"