What is the most common type of weapon that causes death?
the most common type of weapon refers to max(count(subject_weapon)); causes death refers to subject_statuses = 'Deceased'
SELECT subject_weapon FROM incidents WHERE subject_statuses = 'Deceased' GROUP BY subject_weapon ORDER BY COUNT(case_number) DESC LIMIT 1
database name:db_id shooting
Incidents table Incidents Cols: case number dtype text, date dtype date, location dtype text, subject statuses dtype text, subject weapon dtype text, subjects dtype text, subject_count dtype integer, officers dtype text, 
officers table officers Cols: case number dtype text, race dtype text, gender dtype text, last name dtype text, first name dtype text, full name dtype text, 
subjects table subjects Cols: case number dtype text, race dtype text, gender dtype text, last name dtype text, first name dtype text, full name dtype text, 
