[프로그래머스/Oracle] Lv2. 가격대 별 상품 개수 구하기

| 문제

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

프로그래머스

 

| 풀이

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