-- 4
CREATE PROCEDURE podnies_zarobki
@D_id INT, @Procent_podwyzki INT
AS
BEGIN
    DECLARE @Liczba_podwyzek INT = 0;
    UPDATE HR..employees
    SET salary = salary + salary*@Procent_podwyzki/100
    WHERE department_id=@D_id AND
    salary = (SELECT min_salary FROM HR..jobs j WHERE j.job_id = job_id);
    SET @Liczba_podwyzek = @@ROWCOUNT

    DECLARE @PrintMessage varchar(50);
    IF @Liczba_podwyzek = 0
        SET @PrintMessage = 'Nie ma takich pracownikow'
    ELSE
        SET @PrintMessage = 'Podwyzszono zarobki ' + @Liczba_podwyzek + ' pracownikom'
    PRINT @PrintMessage
END;
GO;