5. Salary Level Function

CREATE FUNCTION ufn_get_salary_level(salary DOUBLE)
RETURNS VARCHAR(20)
BEGIN
DECLARE salary_level VARCHAR(20);
CASE
    WHEN salary < 30000 THEN SET salary_level := 'Low';
    WHEN salary <= 50000 THEN SET salary_level := 'Average';
    WHEN salary > 50000 THEN SET salary_level := 'High';
END CASE;
RETURN salary_level;
END