대장균의 크기에 따라 분류하기 2

SELECT ID, 
    CASE 
        WHEN RANK_SIZE <= ((SELECT COUNT(*) FROM ECOLI_DATA) * 0.25) THEN 'CRITICAL' 
        WHEN RANK_SIZE <= ((SELECT COUNT(*) FROM ECOLI_DATA) * 0.50) THEN 'HIGH' 
        WHEN RANK_SIZE <= ((SELECT COUNT(*) FROM ECOLI_DATA) * 0.75) THEN 'MEDIUM' 
        ELSE'LOW' 
    END AS COLONY_NAME 
FROM (
    SELECT ID, RANK() OVER (ORDER BY SIZE_OF_COLONY DESC) AS RANK_SIZE 
    FROM ECOLI_DATA
) AS _
ORDER BY 1