[프로그래머스] SQL 고득점 Kit: 가격대 별 상품 개수 구하기

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

프로그래머스

 

 

처음에는 풀이2로 풀었으나 너무 노가다라는 생각에 풀이1로 풀었다

 

풀이1

내림 연산 (floor)을 이용한 풀이

-- 코드를 입력하세요
SELECT floor(PRICE/10000)*10000 as PRICE_GROUP, count(*) as PRODUCTS
from PRODUCT
group by PRICE_GROUP
order by PRICE_GROUP asc

 

풀이2

case when then 과 between 을 이용한 풀이

-- 코드를 입력하세요
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
        when PRICE between 90000 and 99999 then 90000
        end) as PRICE_GROUP,
        count(*) as PRODUCTS
from PRODUCT
group by PRICE_GROUP
order by PRICE_GROUP asc