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