Convert › F176
Burglary by Beat
CJIRetireDataset query (SQL Server)
SELECT i.beat, CONVERT(char(7), i.occurred_date, 126) AS month, COUNT(*) AS incidents FROM incident i WHERE i.offense_code = '220' AND 1 = 1 AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.beat, CONVERT(char(7), i.occurred_date, 126)