SQL group by date (hour)，数据库按小时分组统计数据量

SELECT COUNT(1), TRUNC(BEGINTIME, 'HH24') 
FROM TASK
-- WHERE BEGINTIME > '2022-03-01'
GROUP BY TRUNC(BEGINTIME, 'HH24')
ORDER BY COUNT(1) desc;