What are all the aircraft names?
select aircraft from aircraft
How many matches have each won?
select t1.aircraft, count(*) from aircraft as t1 join match as t2 on t1.aircraft_id = t2.winning_aircraft group by t2.winning_aircraft
How about those that have not won any matches?
select aircraft from aircraft where aircraft_id not in (select winning_aircraft from match)