[프로그래머스] 문제 44. 가격대 별 상품 개수 구하기

20240703 풀이

-- 코드를 입력하세요
SELECT CASE WHEN PRICE >= 0 AND PRICE < 10000 THEN 0
            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
            WHEN PRICE >= 90000 AND PRICE < 100000 THEN 90000
            END PRICE_GROUP
     , COUNT(*) PRODUCTS
FROM PRODUCT
GROUP BY 1
ORDER BY 1

---

20240816 풀이

-- 만원 단위의 가격대 별로 상품 개수 출력
-- PRICE_GROUP, PRODUCTS
-- 가격대를 기준으로 오름차순
SELECT *
FROM PRODUCT;

SELECT FLOOR(PRICE / 10000) * 10000 AS PRICE_GROUP
    , COUNT(*) AS PRODUCTS
FROM PRODUCT
GROUP BY PRICE_GROUP
ORDER BY PRICE_GROUP;

---

20250504 풀이

-- 만 원 단위 가격대 별 상품 개수
-- 각 컬럼명 PRICE_GROUP, PRODUCTS
-- 가격대 기준 오름차순
SELECT *
FROM PRODUCT;

SELECT TRUNCATE(PRICE, -4) AS PRICE_GROUP
     , COUNT(PRODUCT_ID) AS PRODUCTS
FROM PRODUCT
GROUP BY PRICE_GROUP
ORDER BY PRICE_GROUP

 

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

프로그래머스