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: For case number '134472-2015', list the last name of the officers involved and state the subject statuses.

SQL:
SELECT T2.last_name, T1.subject_statuses FROM incidents AS T1 INNER JOIN officers AS T2 ON T1.case_number = T2.case_number WHERE T1.case_number = '134472-2015'