What is the ship id and name that caused most total injuries?
create table death (caused_by_ship_id varchar, PRIMARY KEY (caused_by_ship_id)); create table ship (id varchar, PRIMARY KEY (id))
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