[프로그래머스, 131530] 가격대 별 상품 개수 구하기 (mysql)

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

프로그래머스

728x90

---

SELECT TRUNCATE(price, -4) AS price_group, COUNT(product_id) as products
FROM product
GROUP BY TRUNCATE(price, -4)
ORDER BY price_group