CREATE TABLE aircraft (Aircraft_ID INT, Order_Year INT, Manufacturer TEXT, Model TEXT, Fleet_Series TEXT, Powertrain TEXT, Fuel_Propulsion TEXT)
CREATE TABLE pilot_record (Record_ID INT, Pilot_ID INT, Aircraft_ID INT, Date TEXT)
CREATE TABLE pilot (Pilot_ID INT, Pilot_name TEXT, Rank INT, Age INT, Nationality TEXT, Position TEXT, Join_Year INT, Team TEXT)

Draw a bar chart for what are the different nationalities of pilots? Show each nationality and the number of pilots of each nationality, and 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 NULLS LAST