What are the names of all the winning pilots?
select t1.name from pilot as t1 join match as t2 on t1.pilot_id = t2.winning_pilot
What are the names of the aircrafts that they used?
select t1.name, t3.aircraft from pilot as t1 join match as t2 on t1.pilot_id = t2.winning_pilot join aircraft as t3 on t2.winning_aircraft = t3.aircraft_id
What one of the aircrafts won the most?
select t1.aircraft from aircraft as t1 join match as t2 on t1.aircraft_id = t2.winning_aircraft group by t2.winning_aircraft order by count(*) desc limit 1