declare @emp_id int;
declare @sal float;
declare @min_sal float;
declare @max_sal  float;
declare @a int;
declare @b int;
declare @c int;
declare kursor cursor for SELECT e.employee_id,e.salary,j.min_salary, j.max_salary FROM employees e, jobs j where e.job_id = j.job_id;
BEGIN
open kursor
fetch next from kursor into @emp_id ,@sal,@min_sal,@max_sal;
WHILE(@@FETCH_STATUS=0)
BEGIN
if(@sal >= @min_sal AND @sal< @min_sal+0.3*(max_sal-min_sal) set @a=@a+1;
if(@sal >= @min_sal+ 0.3*(@max_sal-@min_sal) AND @sal< @min_sal+ 0.7*(max_sal-min_sal) set @b=@b+1;
if(@sal >= @min_sal+ 0.7*(max_sal-min_sal) AND @sal<= @max_sal set @c=@c+1;
@emp_id ,@sal,@min_sal,@max_sal;@id,@imie,@nazwisko,@data,@salary;
END
print ('a = '+ @a);
print ('b = '+ @b);
print ('c = '+ @c);
END
close kursor;
deallocate kursor;