SELECT TRUNCATE(PRICE, -4) PRICE_GROUP, COUNT(*) PRODUCTS
FROM PRODUCT
GROUP BY PRICE_GROUP
ORDER BY PRICE_GROUP
TRUNCATE(12.34 ,1) -> 12.3
TRUNCATE(12.34 ,-1) -> 10
CASE 컬럼명 | 표현식 WHEN 조건식1 THEN 결과1
WHEN 조건식2 THEN 결과2
WHEN 조건식n THEN 결과n
ELSE 결과
END AS ALIAS