CREATE TABLE aircraft (aircraft_id DECIMAL, order_year DECIMAL, manufacturer TEXT, model TEXT, fleet_series TEXT, powertrain TEXT, fuel_propulsion TEXT)
CREATE TABLE pilot_record (record_id DECIMAL, pilot_id DECIMAL, aircraft_id DECIMAL, date TEXT)
CREATE TABLE pilot (pilot_id DECIMAL, pilot_name TEXT, rank DECIMAL, age DECIMAL, nationality TEXT, position TEXT, join_year DECIMAL, team TEXT)

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" AS "T1" JOIN "pilot" AS "T2" ON "T1"."pilot_id" = "T2"."pilot_id" GROUP BY "T2"."pilot_name"