Database: pilot_1
Question: Find the name of the oldest pilot for each type of plane, and order the results by plane name.
SQL:
SELECT pilot_name ,  plane_name ,  max(age) FROM pilotskills GROUP BY plane_name ORDER BY plane_name