Database schema:

CREATE TABLE incidents (
	case_number TEXT NOT NULL, 
	date DATE NOT NULL, 
	location TEXT NOT NULL, 
	subject_statuses TEXT NOT NULL, 
	subject_weapon TEXT NOT NULL, 
	subjects TEXT NOT NULL, 
	subject_count INTEGER NOT NULL, 
	officers TEXT NOT NULL, 
	PRIMARY KEY (case_number)
)


CREATE TABLE officers (
	case_number TEXT NOT NULL -- example: ['121982X', '44523A'],
	race TEXT -- example: ['L', 'W'],
	gender TEXT NOT NULL -- example: ['M', 'F'],
	last_name TEXT NOT NULL -- example: ['Fillingim', 'Patino'],
	first_name TEXT -- example: ['Brian', 'Michael'],
	full_name TEXT NOT NULL -- example: ['Fillingim, Brian', 'Patino, Michael'],
	CONSTRAINT fk_officers_incidents FOREIGN KEY(case_number) REFERENCES incidents (case_number)
)


CREATE TABLE subjects (
	case_number TEXT NOT NULL -- example: ['121982X', '44523A'],
	race TEXT NOT NULL -- example: ['L', 'B'],
	gender TEXT NOT NULL -- example: ['M', 'F'],
	last_name TEXT NOT NULL -- example: ['Curry', 'Chavez'],
	first_name TEXT -- example: ['Gabriel', 'James'],
	full_name TEXT NOT NULL -- example: ['Curry, James', 'Chavez, Gabriel'],
	CONSTRAINT fk_subjects_incidents FOREIGN KEY(case_number) REFERENCES incidents (case_number)
)

Question: Which near-death incident did a policeman by the name of Ruben Fredirick look into? What is the victim in this incident's race and gender?
Evidence: near-death refers to subject_statuses = 'Deceased Injured'; incident refers to case_number; Ruben Fredirick refers to full_name = 'Ruben Fredirick'

SQL:
SELECT T1.case_number, T3.race, T3.gender FROM incidents AS T1 INNER JOIN officers AS T2 ON T1.case_number = T2.case_number INNER JOIN subjects AS T3 ON T1.case_number = T3.case_number WHERE T2.first_name = 'Fredirick' AND T2.last_name = 'Ruben'