### 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:
How many people were injured between 2006 and 2014 as a result of a handgun?

### Extra Knowledge:
injured refers to subject_statuses = 'injured'; between 2006 and 2014 refers to date between '2006-01-01' and '2013-12-31'; handgun refers to subject_weapon = 'handgun'; where the incidents took place refers to location
SELECT COUNT(location) FROM incidents WHERE subject_weapon = 'Handgun' AND subject_statuses = 'Injured' AND date BETWEEN '2006-01-01' AND '2013-12-31'