SELECT stud_name INTO @s_name FROM student

update student set stip=stip*@kf

DROP PROCEDURE IF EXISTS stat();

FOR SELECT id_stud, avg(mark) from progress group by id_stud into @sn, @avg_bal do if @avg_bal >=4 then update student set stip=1200;

SET @x=0