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)
CREATE TABLE pilot (pilot_id NUMBER, pilot_name CLOB, rank NUMBER, age NUMBER, nationality CLOB, position CLOB, join_year NUMBER, team CLOB)

Show the names of pilots and the number of records they have.
SELECT T2.pilot_name, COUNT(*) FROM pilot_record AS T1 JOIN pilot AS T2 ON T1.pilot_id = T2.pilot_id GROUP BY T2.pilot_name
SELECT "T2"."pilot_name", COUNT(*) FROM "pilot_record" "T1" JOIN "pilot" "T2" ON "T1"."pilot_id" = "T2"."pilot_id" GROUP BY "T2"."pilot_name"