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

### Extra Knowledge:

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'