Task: Text to Code
Input (English): Step 1: For each row in ship table, find corresponding rows in battle table and in death table.
Step 2: find note of the results of step 1 whose date contains East
Output (English): SELECT T3.note FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle JOIN death AS T3 ON T2.id = T3.caused_by_ship_id WHERE T1.date LIKE "East"