How many pilots are under 30?
select count(*) from pilot where age < 30
What are their names and ages?
select name, age from pilot where age < 30
How many times have they each won?
select t1.name, t1.age, count(*) from pilot as t1 join match as t2 on t1.pilot_id = t2.winning_pilot group by t2.winning_pilot
Show me the name and age of the one that has won the most times.
select t1.name, t1.age from pilot as t1 join match as t2 on t1.pilot_id = t2.winning_pilot where t1.age < 30 group by t2.winning_pilot order by count(*) desc limit 1