declare
v_avgsal employees.salary%TYPE;
begin
select avg(salary) into v_avgsal from empolyees where department_id = 50;
if v_avgsal < 5000 then
update employees set salary = salary + 1000 where department_id = 50;
end if;
end;
declare
v_avgsal employees.salary%TYPE;
begin
select avg(salary) into v_avgsal from empolyees where department_id = 50;
if v_avgsal < 5000 then
update employees set salary = salary + 1000 where department_id = 50;
end if;
end;