How many records in total?
select count(*) from pilot_record
Show the pilot names where there is at lease one record.
select t2.pilot_name from pilot_record as t1 join pilot as t2 on t1.pilot_id = t2.pilot_id group by t2.pilot_name
Show the names and the corresponding number of records.
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