oracle 空值 group by,为什么group by 没有将一样的数据合为一条

为什么我group by之后数据没合在一块

select esi.id as sectionId,

ecc.cc_no as ccNo,

esi.section_name as sectionName,

decode(ee.issubmit, NULL, 'no', 0, 'no', 'yes') as submitStatus,

sum(ee.week_idle_hours) as completed,

emi.name as submitPeople,

to_char(ee.app_date1, 'yyyy-MM-dd hh24:mi:ss') as submitDate,

eei.id,

esi.id,

ecc.id,

ecd.id,

emi.id

from ETS_ETS          ee,

ETS_EQU_INFO     eei,

ETS_SECTION_INFO esi,

ETS_COSTCENTER   ecc,

ETS_COORDINATOR  ecd,

ETS_EMP_INFO     emi

where ee.equ_id = eei.id

and eei.section_id = esi.id

and esi.cc_id = ecc.id

and ecd.cc_id = ecc.id

and ecd.cood_id = emi.id

and ee.app_by1 is not null

and ee.app_by2 is null

and (ee.issubmit = '1' or