[프로그래머스] Lv.3 대장균의 크기에 따라 분류하기 2 (NTILE OVER)

답

SELECT ID,
    CASE
        WHEN NTILE(4) OVER (ORDER BY SIZE_OF_COLONY) = 1 THEN 'LOW'
        WHEN NTILE(4) OVER (ORDER BY SIZE_OF_COLONY) = 2 THEN 'MEDIUM'
        WHEN NTILE(4) OVER (ORDER BY SIZE_OF_COLONY) = 3 THEN 'HIGH'
        ELSE 'CRITICAL'
        END AS COLONY_NAME
FROM ECOLI_DATA
ORDER BY ID

풀이

◽ NTILE

MySQL 순위 함수 - muaga's Hub

MySQL 순위 함수 | MySQL

https://inblog.ai/muaga/mysql-순위-함수-21203