select to_char(begin_time, 'yyyy-mm-dd hh24'), trunc(to_char(begin_time, 'mi')/10), count(1), sum(log_num)
from tb_e2e_trace_0616
group by to_char(begin_time, 'yyyy-mm-dd hh24'), trunc(to_char(begin_time, 'mi')/10)
order by to_char(begin_time, 'yyyy-mm-dd hh24'), trunc(to_char(begin_time, 'mi')/10)
from tb_e2e_trace_0616
group by to_char(begin_time, 'yyyy-mm-dd hh24'), trunc(to_char(begin_time, 'mi')/10)
order by to_char(begin_time, 'yyyy-mm-dd hh24'), trunc(to_char(begin_time, 'mi')/10)