### 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:
In which year has the greatest number of cases where Handgun was used as weapon?

### Extra Knowledge:
year refers to year(date); the greatest number of cases refers to max(count(case_number)); OS Spray was used as weapon refers to subject_weapon = 'OS Spray'
SELECT STRFTIME('%Y', date) FROM incidents WHERE subject_weapon = 'Handgun' GROUP BY STRFTIME('%Y', date) ORDER BY COUNT(case_number) DESC LIMIT 1