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