art_in_sky Contributor

Thank you Marcel and Jones for your answers. Both of the queries worked for me . I am curious to know why my CASE statement with BETWEEN didn't work and I believe they are in order, Aren't they?

Please find my beast mode calculation below CASE WHEN `New_Column_Name` < 5 THEN 'Less than 5' WHEN `New_Column_Name` BETWEEN 5 AND 10 THEN '5-10' WHEN `New_Column_Name` BETWEEN 11 AND 20 THEN '11-20' WHEN `New_Column_Name` BETWEEN 21 AND 30 THEN '21-30' WHEN `New_Column_Name` BETWEEN 31 AND 50 THEN '31-50' WHEN…