What are the names of the aircraft?
select aircraft from aircraft
And which of those aircraft won a match?
select t1.aircraft from aircraft as t1 join match as t2 on t1.aircraft_id = t2.winning_aircraft
How many have won at least two matches?
select t1.aircraft from aircraft as t1 join match as t2 on t1.aircraft_id = t2.winning_aircraft group by t2.winning_aircraft having count ( * ) > = 2