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

What are the different nationalities of pilots? Show each nationality and the number of pilots of each nationality Show bar chart, display by the names in desc.
SELECT Nationality, COUNT(*) FROM pilot GROUP BY Nationality ORDER BY Nationality DESC
SELECT "Nationality", COUNT(*) FROM "pilot" GROUP BY "Nationality" ORDER BY "Nationality" DESC