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)

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