这个很容易,如下,这里的高手都死到那里去了,还要我亲自动手
update sc
set grade=grade*1.05
where s# (select s# from s
where sex='F' and (select grade<avg(grade)
from sc))
update sc
set grade=grade*1.05
where s# (select s# from s
where sex='F' and (select grade<avg(grade)
from sc))
set grade=grade*1.05
where s# in (select s# from s
where sex='F' and grade<(select avg(grade)
from sc))