select to_char (create_time,'hh24') || ':' || lpad(floor(create_time),'mi') / 5)* 5,2,0) cjsj, count(order_no) num from NCPAY_FIND_CARD_INFO
where create_time > to_date ('2022-06-28 00:00:00' ,'yyyy-MM-dd hh24:mi:ss')
and create_time <= to_date ('2022-06-28 00:00:00' ,'yyyy-MM-dd hh24:mi:ss')
group by to_char (create_time,'hh24') || ':' || lpad(floor(create_time),'mi') / 5)* 5,2,0)
order by to_char (create_time,'hh24') || ':' || lpad(floor(create_time),'mi') / 5)* 5,2,0)