mysql 用if语句查询

DELIMITER //

CREATE PROCEDURE GetEmployeeDetails(IN employeeId INT)
BEGIN
    DECLARE employeeName VARCHAR(255);
    DECLARE employeeSalary DECIMAL(10, 2);

    SELECT name, salary INTO employeeName, employeeSalary FROM employees WHERE id = employeeId;

    IF employeeSalary > 5000 THEN
        SELECT CONCAT('Employee Name: ', employeeName, ', Salary: ', employeeSalary, ', High Earner') AS details;
    ELSEIF employeeSalary BETWEEN 3000 AND 5000 THEN
        SELECT CONCAT('Employee Name: ', employeeName, ', Salary: ', employeeSalary, ', Medium Earner') AS details;
    ELSE
        SELECT CONCAT('Employee Name: ', employeeName, ', Salary: ', employeeSalary, ', Low Earner') AS details;
    END IF;
END //

DELIMITER ;