How many instances were found in June 2015?
in June 2015 refers to date between '2015-06-01' and '2015-06-30'; record number refers to case_number
SELECT COUNT(case_number) FROM incidents WHERE date BETWEEN '2015-06-01' AND '2015-06-30'