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: Among the 'Handgun' weapon used by subject, how many percent were 'Shoot and Miss'?
Evidence: 'Handgun' weapon refers to subject_weapon = 'Handgun'; 'Shoot and Miss' refers to subject_statuses = 'Shoot and Miss'; percent = divide(count(incidents where subject_statuses = 'Shoot and Miss'), count(incidents)) where subject_weapon = 'Handgun' * 100%

SQL:
SELECT CAST(SUM(subject_statuses = 'Shoot and Miss') AS REAL) * 100 / COUNT(case_number) FROM incidents WHERE subject_weapon = 'Handgun'