select filename,
be_id,
trunc(created_time + 1 / 3) record_date,
sum(total_rec_count) / count(1) dsp_num,
sum(succ_rec_count) dsp_suc_num,
sum(err_rec_count) dsp_fail_num,
min(throw_rec_count) dsp_throw_num
from bb_log_dspcdr
where to_char(trunc(created_time + 1 / 3), 'yyyymmdd') = '20181007'
GROUP by filename, be_id, trunc(created_time + 1 / 3);
#created_time + 1/3 : 取created_time 加8个小时的时间
#trunc(created_time + 1 / 3) :取时间的年月日 ,不去时分秒
#GROUP by filename, be_id, trunc(created_time + 1 / 3): 根据三类字段 分组