CREATE TABLE ship (lost_in_battle VARCHAR(255), ship_type VARCHAR(255)); CREATE TABLE battle (id VARCHAR(255), name VARCHAR(255))
What are the different ids and names of the battles that lost any 'Brig' type shipes?
    
SQL: 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'