select
to_char(t.djrq,'yyyy') Year,
to_char(t.djrq,'mm') Month,
to_char(t.djrq,'dd') Day,
substr(t.jg,1,6) AreaCode,
sum(case when t.stable in ('jh','jhbl') then 1 else 0 end) TotalMarriageCount,
sum(case when t.stable in ('lh','lhbl') then 1 else 0 end) TotalDivorceCount
from psn_mz_hunyin t
group by
to_char(t.djrq,'yyyy'),
to_char(t.djrq,'mm'),
to_char(t.djrq,'dd'),
substr(t.jg,1,6)
to_char(t.djrq,'yyyy') Year,
to_char(t.djrq,'mm') Month,
to_char(t.djrq,'dd') Day,
substr(t.jg,1,6) AreaCode,
sum(case when t.stable in ('jh','jhbl') then 1 else 0 end) TotalMarriageCount,
sum(case when t.stable in ('lh','lhbl') then 1 else 0 end) TotalDivorceCount
from psn_mz_hunyin t
group by
to_char(t.djrq,'yyyy'),
to_char(t.djrq,'mm'),
to_char(t.djrq,'dd'),
substr(t.jg,1,6)