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)
CREATE TABLE aircraft (aircraft_id NUMBER, order_year NUMBER, manufacturer CLOB, model CLOB, fleet_series CLOB, powertrain CLOB, fuel_propulsion CLOB)

How many pilots are there?
SELECT COUNT(*) FROM pilot
SELECT COUNT(*) FROM "pilot"