SELECT T2.id ,  T2.name FROM death AS T1 JOIN ship AS t2 ON T1.caused_by_ship_id  =  T2.id GROUP BY T2.id ORDER BY count(*) DESC LIMIT 1
What is the ship id and name that caused most total injuries?
SELECT T2.id , T2.name FROM death AS T1 JOIN ship AS t2 ON T1.caused_by_ship_id = T2.id GROUP BY T2.id ORDER BY count ( * ) DESC LIMIT 1
select t2 . id , t2 . name from death as t1 join ship as t2 on t1 . caused_by_ship_id = t2 . id group by t2 . id order by count ( * ) desc limit value
What is the ship id and name that caused most total injuries ?