How many records are there?
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
Which pilot has only one record?
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 having count(*) = 1
What about the ones who have more than one record?
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 having count(*) > 1