신입으로 너무 힘드네요 오라클쓰다 ms sql쓰는데 ㅠㅠ

SELECT TOP 100 PERCENT
       A.COUNTRY_NAME COL2,
       A.GUBUN COL1, A.CNT, A.COUNTRY_CODE, A.RIGHT_DIV
FROM
(
    SELECT DBO.FN_COUNTRY_NAME(COUNTRY_CODE) COUNTRY_NAME
    ,DBO.FN_COM_CODE_NAME('RIGHT_DIV', RIGHT_DIV, 'ko-kr', 'ko-kr')+'출원' GUBUN, COUNT(*) CNT, COUNTRY_CODE, RIGHT_DIV
    FROM TB_APP_MST
    WHERE DBO.FN_ISNULL(APP_NO, NULL) IS NOT NULL
      AND DBO.FN_ISNULL(REG_NO, NULL) IS NULL
      AND ABD_YN <> '1'
      AND RIGHT_DIV <> '40'
    GROUP BY COUNTRY_CODE, RIGHT_DIV
    UNION ALL
    SELECT DBO.FN_COUNTRY_NAME(COUNTRY_CODE) COUNTRY_NAME
    ,DBO.FN_COM_CODE_NAME('RIGHT_DIV', RIGHT_DIV, 'ko-kr', 'ko-kr')+'등록' GUBUN, COUNT(*) CNT, COUNTRY_CODE, RIGHT_DIV
    FROM TB_APP_MST
    WHERE DBO.FN_ISNULL(REG_NO, NULL) IS NOT NULL
      AND ABD_YN <> '1'
      AND RIGHT_DIV <> '40'
    GROUP BY COUNTRY_CODE, RIGHT_DIV
) A
ORDER BY A.COUNTRY_NAME

이쿼린데 기간 조건을 주고 싶어서 사이에 {#main}을 넣어서

SELECT TOP 100 PERCENT
       A.COUNTRY_NAME COL2,
       A.GUBUN COL1, A.CNT, A.COUNTRY_CODE, A.RIGHT_DIV
FROM
(
    SELECT DBO.FN_COUNTRY_NAME(COUNTRY_CODE) COUNTRY_NAME
    ,DBO.FN_COM_CODE_NAME('RIGHT_DIV', RIGHT_DIV, 'ko-kr', 'ko-kr')+'출원' GUBUN, COUNT(*) CNT, COUNTRY_CODE, RIGHT_DIV
    FROM TB_APP_MST
    WHERE DBO.FN_ISNULL(APP_NO, NULL) IS NOT NULL
      AND DBO.FN_ISNULL(REG_NO, NULL) IS NULL
      AND ABD_YN <> '1'
      AND RIGHT_DIV <> '40'
      AND APP_DATE >= '20110523'
      AND APP_DATE <= '20110523'
    GROUP BY COUNTRY_CODE, RIGHT_DIV
    UNION ALL
    SELECT DBO.FN_COUNTRY_NAME(COUNTRY_CODE) COUNTRY_NAME
    ,DBO.FN_COM_CODE_NAME('RIGHT_DIV', RIGHT_DIV, 'ko-kr', 'ko-kr')+'등록' GUBUN, COUNT(*) CNT, COUNTRY_CODE, RIGHT_DIV
    FROM TB_APP_MST
    WHERE DBO.FN_ISNULL(REG_NO, NULL) IS NOT NULL
      AND ABD_YN <> '1'
      AND RIGHT_DIV <> '40'
      AND APP_DATE >= '20110523'
      AND APP_DATE <= '20110523'
    GROUP BY COUNTRY_CODE, RIGHT_DIV
) A
ORDER BY A.COUNTRY_NAME

이렇게 했는데 결과가 뜨질 않네요 ㅠㅠ

에효 ms sql어려워요 ㅠㅠ