### 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:
What percentage of deaths were caused by rifles?

### Extra Knowledge:
rifle refers to subject_weapon = 'rifles'; death refers to subject_statuses = 'Deceased'; percentage = divide(count(incidents where subject_weapon = 'rifles'), count(incidents)) where subject_statuses = 'Deceased' * 100%
SELECT CAST(SUM(subject_statuses = 'Deceased') AS REAL) * 100 / COUNT(case_number) FROM incidents WHERE subject_weapon = 'Rifle'