가격대 별 상품 개수 구하기

[ji-0630]

문제 설명

[ji-0630]

다른 사람의 풀이

SELECT (price div 10000) * 10000 as PRICE_GROUP, count(*) as PRODUCTS
from PRODUCT
group by PRICE_GROUP
order by PRICE_GROUP

[ji-0630]

다시 풀기

SELECT (PRICE div 10000) * 10000 as "PRICE_GROUP", count(PRODUCT_ID) as "PRODUCTS"
from PRODUCT
group by PRICE_GROUP
order by PRICE_GROUP

• div: 값을 정수로 반환

[ji-0630]

다시 풀기

SELECT (PRICE div 10000) * 10000 as "PRICE_GROUP", count(*) as "PRODUCTS"
from PRODUCT
group by PRICE_GROUP
order by PRICE_GROUP