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