💻 하나씩 차곡차곡/프로그래머스 (SQL)
[GROUP BY/LEVEL2] 가격대 별 상품 개수 구하기(MySQL/Oracle)
뚜루리
2023. 4. 19. 07:48
728x90
320x100
MySQL/Oracle
SELECT
SUBSTR(PRICE, 1, 1) * 10000 AS PRICE_GROUP
,COUNT(*) AS PRODUCTS
FROM PRODUCT
GROUP BY SUBSTR(PRICE,1,1)*10000
ORDER BY PRICE_GROUP
728x90
320x100