Task: Text to Code
Input (English): What is the ship id and name that caused most total injuries?
Output (English): 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