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.
SELECT nationality, COUNT(*) FROM pilot GROUP BY nationality
SELECT "nationality", COUNT(*) FROM "pilot" GROUP BY "nationality"