Show all the information for all the pilots!
select * from pilot
Show me only the winning-pilots!
select * from pilot as t1 join match as t2 on t1.pilot_id = t2.winning_pilot
What is the name and age of the oldest one?
select t1.name, t1.age from pilot as t1 join match as t2 on t1.pilot_id = t2.winning_pilot order by t1.age desc limit 1
How about the youngest one?
select t1.name, t1.age from pilot as t1 join match as t2 on t1.pilot_id = t2.winning_pilot order by t1.age asc limit 1