截取某列字段前俩位并求和

SELECT 
    dept,
    SUM(num)
FROM
(
SELECT
	substr(DEPT_ID,0,2) dept,
	COUNT (*) num
FROM
	saf_t_hidden_danger bc
WHERE
	bc.DEL_FLAG = '0'
AND bc.CREATE_DATE >= TO_DATE ('2019-03-18', 'yyyy-MM-dd')
AND bc.CREATE_DATE  <= TO_DATE ('2019-03-24', 'yyyy-MM-dd')
GROUP BY
	DEPT_ID
ORDER BY
	DEPT_ID
)a
where 
    1= 1
GROUP BY
    dept