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)

Bar graph to show the total number from different nationality, list in ascending by the the total number .
SELECT Nationality, COUNT(*) FROM pilot GROUP BY Nationality ORDER BY COUNT(*)
SELECT "Nationality", COUNT(*) FROM "pilot" GROUP BY "Nationality" ORDER BY COUNT(*)