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 whose flno contains 99
Output (English): SELECT T2.name FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid WHERE T1.flno LIKE 99