가격대 별 상품 개수 구하기 - Oracle

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