SELECT T1.id ,  T1.name FROM battle AS T1 JOIN ship AS T2 ON T1.id  =  T2.lost_in_battle JOIN death AS T3 ON T2.id  =  T3.caused_by_ship_id GROUP BY T1.id HAVING sum(T3.killed)  >  10
What are the ids and names of the battles that led to more than 10 people killed in total.
SELECT T1.id , T1.name FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle JOIN death AS T3 ON T2.id = T3.caused_by_ship_id GROUP BY T1.id HAVING sum ( T3.killed ) > 10
select t1 . id , t1 . name from battle as t1 join ship as t2 on t1 . id = t2 . lost_in_battle join death as t3 on t2 . id = t3 . caused_by_ship_id group by t1 . id having sum ( t3 . killed ) > value
What are the ids and names of the battles that led to more than 10 people killed in total .