For each aircraft that has won an award, what is its name and how many time has it 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