Database: pilot_1
Question: What are the different plane names, and what are the names of the oldest pilot who has each, ordered by plane name?
SQL:
SELECT pilot_name ,  plane_name ,  max(age) FROM pilotskills GROUP BY plane_name ORDER BY plane_name