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  =  'Brig'
[{'id': 8, 'name': 'Siege of Constantinople'}, {'id': 7, 'name': 'Battle of Philippopolis'}, {'id': 6, 'name': 'Battle of Boruy'}, {'id': 5, 'name': 'Battle of Messinopolis'}, {'id': 4, 'name': 'Battle of Rodosto'}]