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

SELECT ID, 
CASE
    WHEN SIZE_OF_COLONY <= 100 THEN 'LOW'
    WHEN SIZE_OF_COLONY > 100 AND SIZE_OF_COLONY <= 1000 THEN 'MEDIUM' 
    WHEN SIZE_OF_COLONY > 1000 THEN 'HIGH' 
END AS SIZE 
FROM ECOLI_DATA 
ORDER BY ID