Which aircraft won the most matches?
SELECT winning_aircraft FROM match group by winning_aircraft order by count ( * )  desc limit 1
aircraft won the most matches refers to MAX(COUNT(winning_aircraft));