Their names.
select aircraft from aircraft where aircraft_id not in ( select winning_aircraft from match )
Which pilot won the most matches?
select winning_pilot from match group by winning_pilot order by count ( * ) desc limit 1
Which aircraft won the most matches?
select winning_aircraft from match group by winning_aircraft order by count ( * ) desc limit 1