Bucket Value

bucket_value.sql

SELECT COUNT(1) AS total
, CASE 
WHEN measure <= 0 THEN '0-10' 
WHEN measure <= 100 THEN CONCAT(CEIL(measure/10)*10-10,'-',CEIL(measure/10)*10)
WHEN measure <= 30000 THEN CONCAT(CEIL(measure/50)*50-50,'-',CEIL(measure/50)*50)
WHEN measure > 30000 THEN 'over 30000'
ELSE NULL
END AS bucket
, CASE 
WHEN measure <= 100 THEN CEIL(measure/10)*10
WHEN measure <= 30000 THEN CEIL(measure/50)*50
WHEN measure > 30000 THEN 30001
ELSE 0
END AS sort_no_use
FROM TABLE
WHERE 1
GROUP BY bucket
ORDER BY sort_no_use