Oracle
[프로그래머스] 가격대 별 상품 개수 구하기
dearbeany
2023. 11. 22. 20:43
select substr(price,1,1)*10000 as "price_group", count(*) as products
from product
group by substr(price,1,1)*10000
order by substr(price,1,1)*10000;