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

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

프로그래머스

정답

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

풀이 단계

STEP 1) 가격대 만들기

SELECT DISTINCT FLOOR(PRICE/10000)
FROM PRODUCT 
ORDER BY 1
;

SELECT DISTINCT FLOOR(PRICE/10000)*1000
FROM PRODUCT 
ORDER BY 1
;

STEP 2) 그룹 하기

SELECT FLOOR(PRICE/10000)*10000 PRICE_GROUP 
FROM PRODUCT 
GROUP BY FLOOR(PRICE/10000)
ORDER BY 1

STEP 3) COUNT() 함수 넣기

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