按照日期对数据进行分组展示

select sum(count1),fendtime,fshop,freporter from (SELECT 0 as count1,

           a.daylist as fendtime,
           b.FSHOP,
           c.FREPORTER
    FROM (
             SELECT TO_CHAR(TO_DATE(to_char(SYSDATE, 'yyyy-MM-dd'), 'yyyy-MM-dd') - ROWNUM + 1,
                            'yyyy-MM-dd') AS daylist
             FROM DUAL
             CONNECT BY ROWNUM <= 30
         ) a,
         (select distinct FSHOP from T_AEGONGDAN_MSHENGCHANZHIXING_PREPORT_0002) b,

         (select distinct freporter from T_AEGONGDAN_MSHENGCHANZHIXING_PREPORT_0002) c

    union all
    select sum(FQUALIFIED), to_char(FENDTIME, 'yyyy-MM-dd'), fshop, freporter
    from T_AEGONGDAN_MSHENGCHANZHIXING_PREPORT_0002 a
    where a.FENDTIME > TO_DATE(to_char(SYSDATE, 'yyyy-MM-dd'), 'yyyy-MM-dd') - 7
      and a.FENDTIME < TO_DATE(to_char(SYSDATE, 'yyyy-MM-dd'), 'yyyy-MM-dd')
    group by fshop, freporter, FENDTIME
   )  d group by fendtime, fshop, freporter order by fendtime;