RC-LS, CheckEye DX

---생활습관병 치환 시뮬레이션 사용고객

SELECT current_database() gbn, b.mdi_id, b.cstm_nm, b.contract_stat , to_char(a.cre_Dttm, 'yyyymmdd') cre_day, count(*) OVER( PARTITION BY a.cstm_id, b.cstm_nm, b.contract_stat ) AS using_count ,a.cstm_id

FROM rar3020f a, cmi1000m b

WHERE 1=1

AND a.cstm_id = b.cstm_id

AND a.cstm_id NOT IN ( '0110123456','4710000777')

GROUP BY a.cstm_id, b.mdi_id, b.cstm_nm, b.contract_stat ,to_char(a.cre_Dttm, 'yyyymmdd')

ORDER BY 1

;