Task: Text to Code
Input (English): SQL: SELECT DISTINCT id , name FROM ship WHERE ship_type = "Brig"
Feedback: Need to swap ship table with battle table .
Output (English): SELECT DISTINCT T1.id ,  T1.name FROM battle AS T1 JOIN ship AS T2 ON T1.id  =  T2.lost_in_battle WHERE T2.ship_type  =  'Brig'