create table tt ( name char(10), courseid char(10), score int )
insert into tt values('1','1001',67) insert into tt values('2','1002',27) insert into tt values('3','1002',67) insert into tt values('4','1003',67) insert into tt values('5','1001',43) insert into tt values('6','1001',40) insert into tt values('7','1002',67) insert into tt values('8','1001',29) insert into tt values('9','1003',33) insert into tt values('10','1001',24) go while (select avg(score) from tt where courseid='1001')<45 begin update tt set score=score*1.01 where courseid='1001' if(select max(score) from tt where courseid='1001')>70 break else continue end
(
name char(10),
courseid char(10),
score int
)
insert into tt values('1','1001',67)
insert into tt values('2','1002',27)
insert into tt values('3','1002',67)
insert into tt values('4','1003',67)
insert into tt values('5','1001',43)
insert into tt values('6','1001',40)
insert into tt values('7','1002',67)
insert into tt values('8','1001',29)
insert into tt values('9','1003',33)
insert into tt values('10','1001',24)
go
while (select avg(score) from tt where courseid='1001')<45
begin
update tt set score=score*1.01 where courseid='1001'
if(select max(score) from tt where courseid='1001')>70
break
else
continue
end