SELECT
    *
FROM
    (
    SELECT
/*+ FIRST_ROWS(50) */
        SITE_CODE,
        ( SELECT UNIT || ' ' || NAME FROM SITE WHERE SITE_CODE_EXIST = A.SITE_CODE AND SITE_TYPE_ID = 5 ) SITE_NAME,
        LOCATION_CODE,
        LOCATION_NAME,
        POWER,
        SUSPECT_CATEGORY,
        JUMLAH,
        ROW_NUMBER () OVER ( ORDER BY POWER DESC, JUMLAH DESC, LAST_NOTES DESC NULLS LAST ) RN,
        MAX( ROWNUM ) OVER ( ORDER BY NULL ) CNT,
        LAST_NOTES
    FROM
        (
        SELECT
            SITE_CODE,
            A.LOCATION_CODE,
            LOCATION_NAME,
            POWER,
            SUSPECT_CATEGORY,
            COUNT( * ) JUMLAH,
            MAX(((
                        B.UPDATE_DATE - TO_DATE( '19700101', 'YYYYMMDD' )) * 24 * 60 * 60 * 1000
                )) LAST_NOTES
        FROM
            SUSPECT_INSTANTS A
            LEFT JOIN SUSPECT_NOTES B ON A.LOCATION_CODE = B.LOCATION_CODE
        WHERE
            SUSPECT_CATEGORY = '10'
            AND DATE_READ BETWEEN '20190801'
            AND '20190831'
            AND A.LOCATION_CODE = '539411280648'
        GROUP BY
            SITE_CODE,
            A.LOCATION_CODE,
            LOCATION_NAME,
            POWER,
            SUSPECT_CATEGORY
        ) A
    WHERE
        (
            SITE_CODE IN (
                'SUM',
                '56120'
            )
            OR SITE_CODE IN (
                'PST'
            ))
    )
-- WHERE
--  RN BETWEEN ((( 1-1 ) * 1000 ) + 1 )
--  AND ( 1 * 1000 )
-- ORDER BY
--  RN;