[프로그래머스_mysql] 가격대 별 상품 개수 구하기

---

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

프로그래머스

 

---

문제

---

풀이

SELECT CASE WHEN PRICE BETWEEN 0 AND 9999 THEN '0'
WHEN PRICE BETWEEN 10000 AND 19999 THEN '10000'
WHEN PRICE BETWEEN 20000 AND 29999 THEN '20000'
WHEN PRICE BETWEEN 30000 AND 39999 THEN '30000'
WHEN PRICE BETWEEN 40000 AND 49999 THEN '40000'
WHEN PRICE BETWEEN 50000 AND 59999 THEN '50000'
WHEN PRICE BETWEEN 60000 AND 69999 THEN '60000'
WHEN PRICE BETWEEN 70000 AND 79999 THEN '70000'
WHEN PRICE BETWEEN 80000 AND 89999 THEN '80000'
ELSE '90000' END PRICE_GROUP, COUNT(*)
FROM PRODUCT
GROUP BY PRICE_GROUP
order by PRICE_GROUP