Task: Text to Code
Input (English): Step 1: For each row in aircraft table, find the corresponding rows in flight table.
Step 2: find origin, name of the results of step 1 whose price greater than 300
Output (English): SELECT T1.origin , T2.name FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid WHERE T1.price > 300