How many aircrafts are there?
select count(*) from aircraft
What are their names?
select aircraft from aircraft
Which ones have won?
select t1.aircraft from aircraft as t1 join match as t2 on t1.aircraft_id = t2.winning_aircraft
How any times 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