sql实现按小时统计查询

SELECT to_char(date_cr, 'yyyy-mm-dd : HH24') AS create_time, COUNT(date_cr) AS counts
FROM t_task
WHERE date_cr > '2022-03-17 00:00:00'
GROUP BY create_time
ORDER BY create_time DESC;