DELIMITER //
CREATE PROCEDURE ApplyBonus(IN rating INT)
BEGIN
    IF rating = 5 THEN
        UPDATE employees SET salary = salary * 1.10;
    ELSEIF rating = 4 THEN
        UPDATE employees SET salary = salary * 1.05;
    ELSE
        UPDATE employees SET salary = salary * 1.02;
    END IF;
END //
DELIMITER ;

CALL ApplyBonus(5);