-- Database schema
| incidents : case_number [ TEXT ] primary_key , date [ DATE ] , location [ TEXT ] , subject_statuses [ TEXT ] , subject_weapon [ TEXT ] , subjects [ TEXT ] , subject_count [ INTEGER ] , officers [ TEXT ] | officers : case_number [ TEXT ] officers.case_number = incidents.case_number , race [ TEXT ] , gender [ TEXT ] , last_name [ TEXT ] , first_name [ TEXT ] , full_name [ TEXT ] | subjects : case_number [ TEXT ] subjects.case_number = incidents.case_number , race [ TEXT ] , gender [ TEXT ] , last_name [ TEXT ] , first_name [ TEXT ] , full_name [ TEXT ] |
-- -- From the cases where the subject were deceased, list the subject's last name, gender, race and case number.

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';