-- 코드를 입력하세요 SELECT CASE WHEN price then FLOOR(price/10000) * 10000 END as PRICE_GROUP, count(*) as PRODUCTS FROM product GROUP BY 1 ORDER BY 1
1 2 3 4 5 6 7 8 9 10 11 12 -- 코드를 입력하세요 SELECT CASE WHEN price then FLOOR(price/10000) * 10000 END as PRICE_GROUP, count(*) as PRODUCTS FROM product GROUP BY 1 ORDER BY 1
1 2 3 4 5 6 7 8 9 10 11 12
좋은 풀이 잘 보고갑니다! 저는 재귀쿼리를 만들 생각만 했었네요...!