Task: Text to Code
Input (English): Step 1: For each row in aircraft table, find the corresponding rows in flight table.
Step 2: find flno, origin, name of the results of step 1 ordered ascending by destination
Output (English): SELECT T1.flno , T1.origin , T2.name FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid ORDER BY T1.destination Asc