本月新增个人客户数，新增机构客户数统计本月合同金额

SELECT m.orgid YYB,
SUM(DECODE(T2.KHLX,
0,
DECODE(SUBSTR(TO_CHAR(T2.SCTZRQ),
1,
6),
SUBSTR(TO_CHAR(‘201911’), 1, 6),
(T3.HTJE * 1 / 10000),
0),
0)) BY_HTJE_XZ_GRKH,
SUM(DECODE(T2.KHLX, --)
1,
DECODE(SUBSTR(TO_CHAR(T2.SCTZRQ),
1,
6),
SUBSTR(TO_CHAR(‘201911’), 1, 6),
(T3.HTJE * 1 / 10000),
0),
0)) BY_HTJE_XZ_JGKH,
SUM(DECODE(T2.KHLX,
0,
(case when SUBSTR(TO_CHAR(T2.SCTZRQ),
1,
6)<SUBSTR(TO_CHAR(‘201911’), 1, 6)
then (T3.HTJE * 1 / 10000)
else
0 end),–shanxiaoming 20140814 修改存量客户销售额
/* DECODE(SUBSTR(TO_CHAR(T2.SCTZRQ),
1,
6),
SUBSTR(TO_CHAR(V_YF), 1, 6),
0,
(T3.HTJE * 1 / 10000)),*/
0)) BY_HTJE_CL_GRKH,
SUM(DECODE(T2.KHLX,
1,
/DECODE(SUBSTR(TO_CHAR(T2.SCTZRQ),
1,
6),
SUBSTR(TO_CHAR(V_YF), 1, 6),
0,
(T3.HTJE * 1 / 10000)),/
(case when SUBSTR(TO_CHAR(T2.SCTZRQ),
1,
6)<SUBSTR(TO_CHAR(‘201911’), 1, 6)
then (T3.HTJE * 1 / 10000)
else
0 end),
0)) BY_HTJE_CL_JGKH
FROM XTCRM.TKHXX T2，XTCRM.THTXX T3,xtcrm.tryxx m
WHERE T2.ID = T3.KHH
AND T2.YYB IS NOT NULL
and t2.khjl=m.id
and t3.htzt=3 --shanxiaoming 20140819 只通过合同状态为正常的来统计
GROUP BY m.orgid
–select htje from thtxx