What are the different ids and names of the battles that lost any 'Brig' type shipes?
create table ship (lost_in_battle varchar, ship_type varchar, PRIMARY KEY (lost_in_battle)); create table battle (id varchar, name varchar, PRIMARY KEY (id))
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'