Convert › F007
Burglary by Beat
CJIWave 1Dataset 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 i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.beat, CONVERT(char(7), i.occurred_date, 126)