while exists(select 0 where StudentCourse group by StudentID having avg(Grade)<85)
begin
update StudentCourse set Grade=case when Grade>=90 then Grade when Grade>=80 and Grade<90 then Grade+1 when Grade>=70 and Grade<80 then Grade+2 when Grade>=60 and Grade<70 then Grade+3 else Grade+5 end
end
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024