Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE death (caused_by_ship_id VARCHAR, killed INTEGER)
TABLE: CREATE TABLE battle (id VARCHAR, name VARCHAR)
TABLE: CREATE TABLE ship (lost_in_battle VARCHAR, id VARCHAR)

### Question ###
What are the ids and names of the battles that led to more than 10 people killed in total.

### Accurate SQL ###

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