SELECT CH0101.SEIKY_NO, CH0101.SEIKY_YM, CH0101.SVC_KEI_NO, CH0101.PCRS_CD, CH0101.PRC_SVC_CD, CH0101.PRC_KMK_CD, TO_CHAR(CH0101.AMNT), CH0101.MK_FLG FROM CH_T_SEIKY_UCWK CH0101 WHERE CH0101.SEIKY_YM = 'ZZZZZZ' AND CH0101.AMNT > 0 AND CH0101.MK_FLG = '0'