SELECT
    CH0051.SEIKY_KEI_NO
   ,CH0051.KEI_SEIKY_WAY_CD
   ,CH0051.SEIKY_WAY_CD
   ,CH0051.KHRI_RSLT_CD
   ,CH0051.AUTHORI_RSLT_CD
   ,CH0051.SEIKY_SBT_CD
FROM
    CH_T_SEIKY CH0051
WHERE
    CH0051.SEIKY_YM     = 'ZZZZZ'
AND
    CH0051.MK_FLG       = '0'