Task: Text to Code
Input (English): Step 1: For each row in aircraft table, find the corresponding rows in flight table.
Step 2: find name of the results of step 1 ordered descending by price.
Step 3: only show the first 3 rows of the results
Output (English): SELECT T2.name FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid ORDER BY T1.price Desc LIMIT 3