[MySQL] 가격대 별 상품 개수 구하기_ GROUP BY

SELECT (PRICE-PRICE%10000) AS PRICE_GROUP, COUNT(PRODUCT_ID) AS PRODUCTS
FROM PRODUCT
GROUP BY PRICE_GROUP
ORDER BY PRICE_GROUP