가격대 별 상품 개수 구하기

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