[SQL] 가격대 별 상품 개수 구하기

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

 

나의 풀이 코드

SELECT
    CASE 
        WHEN price >= 10000 AND price < 20000 THEN 10000
        WHEN price >= 20000 AND price < 30000 THEN 20000
        WHEN price >= 30000 AND price < 40000 THEN 30000
        WHEN price >= 40000 AND price < 50000 THEN 40000
        WHEN price >= 50000 AND price < 60000 THEN 50000
        WHEN price >= 60000 AND price < 70000 THEN 60000
        WHEN price >= 70000 AND price < 80000 THEN 70000
        WHEN price >= 80000 AND price < 90000 THEN 80000
        END AS PRICE_GROUP
    ,COUNT(product_id) AS PRODUCTS
FROM PRODUCT
GROUP BY 1
ORDER BY 1