👩‍💻 문제

https://school.programmers.co.kr/learn/courses/30/lessons/131530#qna

🙋‍♀️ 답변

SELECT TRUNCATE(PRICE/10000, 0)*10000 AS PRICE_GROUP, COUNT(PRODUCT_CODE) AS PRODUCTS
FROM PRODUCT
GROUP BY PRICE_GROUP
ORDER BY 1 ASC;

🤔

내림 방법이 기억이 안 났다 !! 물론 truncate도 ㅎㅎ

내림 : FLOOR()
자르기 : TRUNCATE()