SELECT
     CH0401.PRC_GRP_CD
    ,CH0401.PCRS_CD
    ,'1'
FROM
    CH_M_PRC_KMK_CS_CHGE CH0401
WHERE
    CH0401.SYS_CD = 'CH'
 AND CH0401.WORK_KINO_SKBT_CD = 'NTTO_ONLY'
 AND CH0401.CHSHT_CHG_CD = '1'
 AND 'ZZZZZ' BETWEEN CH0401.PRC_KMK_CS_CHGE_TSTAYMD AND CH0401.PRC_KMK_CS_CHGE_TENDYMD
 AND CH0401.MK_FLG = '0'