CREATE TABLE pilot (name VARCHAR2, age NUMBER, pilot_id VARCHAR2)
CREATE TABLE MATCH (winning_pilot VARCHAR2)

find the name and age of the pilot who has won the most number of times among the pilots who are younger than 30.
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
SELECT "t1"."name", "t1"."age" FROM "pilot" "t1" JOIN "MATCH" "t2" ON "t1"."pilot_id" = "t2"."winning_pilot" WHERE "t1"."age" < 30 GROUP BY "t2"."winning_pilot" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY