CREATE TABLE pilot (Pilot_name VARCHAR, pilot_ID VARCHAR)
CREATE TABLE pilot_record (pilot_ID VARCHAR)

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"