Which type of weapon was used to attack the victim in the record number 031347-2015? What is the victim's race and gender?
type of weapon refers to subject_weapon; record number 031347-2015 refers to case_number = '031347-2015'
SELECT T1.subject_weapon, T2.race, T2.gender FROM incidents AS T1 INNER JOIN subjects AS T2 ON T1.case_number = T2.case_number WHERE T1.case_number = '031347-2015'
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, 
