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'
What are the different ids and names of the battles that lost any 'Brig' type shipes?
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 '
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 = value
What are the different ids and names of the battles that lost any 'Brig ' type shipes ?