From the cases where the subject were deceased, list the subject's last name, gender, race and case number.
subject were deceased refers to subject_statuses = 'Deceased'
SELECT T2.last_name, T2.gender, T2.race, T2.case_number FROM incidents AS T1 INNER JOIN subjects AS T2 ON T1.case_number = T2.case_number WHERE T1.subject_statuses = 'Deceased'
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, 
