SELECT * FROM Multi_Case ( ON (SELECT *, (age < 1) AS case1, (age >= 1 AND age <= 2) AS case2, (age >= 2 AND age <=12) AS case3, (age >=13 AND age <=19) AS case4, (age >=16 AND age <=25) AS case5, (age >=21 AND age <=40) AS case6, (age >=35 AND age <=60) AS case7, (age >=60) AS case8 FROM people_age ) Labels ( 'case1 AS "infant"', 'case2 AS "toddler"', 'case3 AS "kid"', 'case4 AS "teenager"', 'case5 AS "young adult"', 'case6 AS "adult"', 'case7 AS "middle aged person"', 'case8 AS "senior citizen"' ) ) ORDER BY id;