Write SQL query to solve given problem: How many people were injured between 2006 and 2014 as a result of a handgun?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT COUNT(location) FROM incidents WHERE subject_weapon = 'Handgun' AND subject_statuses = 'Injured' AND date BETWEEN '2006-01-01' AND '2013-12-31'