Comp Time Greater Than 30 Hours

WITH RankedBenefits AS (
    SELECT 
        FILEKEY,
        BENEFIT,
        PAYPERBEGINNING,
        REMAIN,
        ROW_NUMBER() OVER (
            PARTITION BY FILEKEY, BENEFIT 
            ORDER BY PAYPERBEGINNING DESC, UNIQUEID DESC
        ) AS Rn
    FROM EMPLOYEEBENEFITS
    Where BENEFIT = 7
    AND REMAIN > 30
)
SELECT 
    rb.FILEKEY,
    e.LASTNAME+', '+e.FIRSTNAME as Emp,
    b.NAME as Benefit,
    REMAIN
FROM RankedBenefits rb
INNER JOIN EMPLOYEES e On rb.FILEKEY = e.FILEKEY
INNER JOIN BENEFITS b on rb.BENEFIT = b.NUM
WHERE Rn = 1;