-- Database schema
| incidents : case_number [ TEXT ] primary_key , date [ DATE ] , location [ TEXT ] , subject_statuses [ TEXT ] , subject_weapon [ TEXT ] , subjects [ TEXT ] , subject_count [ INTEGER ] , officers [ TEXT ] | officers : case_number [ TEXT ] officers.case_number = incidents.case_number , race [ TEXT ] , gender [ TEXT ] , last_name [ TEXT ] , first_name [ TEXT ] , full_name [ TEXT ] | subjects : case_number [ TEXT ] subjects.case_number = incidents.case_number , race [ TEXT ] , gender [ TEXT ] , last_name [ TEXT ] , first_name [ TEXT ] , full_name [ TEXT ] |
-- -- How many people were injured between 2006 and 2014 as a result of a handgun?

SELECT COUNT(location) FROM incidents WHERE subject_weapon = 'Handgun' AND subject_statuses = 'Injured' AND date BETWEEN '2006-01-01' AND '2013-12-31';