Task: Text to Code
Input (English): Step 1: For each row in battle table, find the corresponding rows in ship table.
Step 2: find battle's name, result, bulgarian_commander of the results of step 1 whose ship's name not equals English Channel
Output (English): SELECT T1.name , T1.result , T1.bulgarian_commander FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.name ! = "English Channel"