가격대별 분포

Custom SQL query returning 7 rows (hide)

SELECT
  CASE
    WHEN price < 10000  THEN '①  ~9,999원'
    WHEN price < 20000  THEN '②  10,000~19,999원'
    WHEN price < 30000  THEN '③  20,000~29,999원'
    WHEN price < 50000  THEN '④  30,000~49,999원'
    WHEN price < 100000 THEN '⑤  50,000~99,999원'
    WHEN price < 200000 THEN '⑥  100,000~199,999원'
    ELSE                     '⑦  200,000원 이상'
  END       AS [가격대],
  COUNT(*)  AS [제품 수]
FROM products
WHERE price IS NOT NULL AND price > 0
GROUP BY [가격대]
ORDER BY [가격대]

Edit SQL