test123

BEGIN
                DECLARE umur INT;
                DECLARE result VARCHAR(5);
                SET umur = TIMESTAMPDIFF(YEAR, tanggal_lahir, CURDATE());

                IF(umur >= 0 AND umur <= 4) THEN
                    SET result = '0-4';
                ELSEIF(umur >= 5 AND umur <= 9) THEN
                    SET result = '5-9';
                ELSEIF(umur >= 10 AND umur <= 14) THEN
                    SET result = '10-14';
                ELSEIF(umur >= 15 AND umur <= 19) THEN
                    SET result = '15-19';
                ELSEIF(umur >= 20 AND umur <= 24) THEN
                    SET result = '20-24';
                ELSEIF(umur >= 25 AND umur <= 29) THEN
                    SET result = '25-29';
                ELSEIF(umur >= 30 AND umur <= 34) THEN
                    SET result = '30-34';
                ELSEIF(umur >= 35 AND umur <= 39) THEN
                    SET result = '35-39';
                ELSEIF(umur >= 40 AND umur <= 44) THEN
                    SET result = '40-44';
                ELSEIF(umur >= 45 AND umur <= 49) THEN
                    SET result = '45-49';
                ELSEIF(umur >= 50 AND umur <= 54) THEN
                    SET result = '50-54';
                ELSEIF(umur >= 55 AND umur <= 59) THEN
                    SET result = '55-59';
                ELSEIF(umur >= 60 AND umur <= 64) THEN
                    SET result = '60-64';
                ELSEIF(umur >= 65 AND umur <= 69) THEN
                    SET result = '65-69';
                ELSEIF(umur >= 70 AND umur <= 74) THEN
                    SET result = '70-74';
                ELSEIF(umur >= 75) THEN
                    SET result = '75+';
                END IF;

                RETURN result;
            END