Task: Text to Code
Input (English): Step 1: For each row in ship table, find the corresponding rows in mission table.
Step 2: find Code, Name, Name of the results of step 1
Output (English): SELECT T1.Code , T2.Name , T2.Name FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID = T2.Ship_ID