### Database Schema:
CREATE TABLE incidents (
	case_number	TEXT	NOT NULL	PRIMARY KEY,
	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
);

CREATE TABLE officers (
	case_number	TEXT	NOT NULL,
	race	TEXT	NULL,
	gender	TEXT	NOT NULL,
	last_name	TEXT	NOT NULL,
	first_name	TEXT	NULL,
	full_name	TEXT	NOT NULL,
	foreign key (case_number) references incidents (case_number)
);

CREATE TABLE subjects (
	case_number	TEXT	NOT NULL,
	race	TEXT	NOT NULL,
	gender	TEXT	NOT NULL,
	last_name	TEXT	NOT NULL,
	first_name	TEXT	NULL,
	full_name	TEXT	NOT NULL,
	foreign key (case_number) references incidents (case_number)
);

### User's Query:
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?

### Extra Knowledge:
near-death refers to subject_statuses = 'Deceased Injured'; incident refers to case_number; Ruben Fredirick refers to full_name = 'Ruben Fredirick'
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'