This is a
SELECT RANK(950) WITHIN GROUP (ORDER BY sal DESC) "Rank", ROUND(100 * (PERCENT_RANK(950) WITHIN GROUP (ORDER BY sal DESC)), 0) "%" FROM emp WHERE job LIKE '%CLERK'