CREATE TABLE pilot (Pilot_name VARCHAR(255), pilot_ID VARCHAR(255)); CREATE TABLE pilot_record (pilot_ID VARCHAR(255))
Show the names of pilots and the number of records they have.
    
SQL: 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