sql查询，帮忙解决下

fish1689999

q315585646

不错不错

喝少了想上树

a)update score set sc_sco=sc_sco+10 where sc_no=345
c)select t1.st_no,t1.st_name,sum(t2.sc_sco)from student t1,score t2 where t1.st_no=t2.sc_no  group by t2.sc_no ;

喝少了想上树

回复 1# fish1689999
a)update score set sc_sco=sc_sco+10 where sc_no=345
b)select t1.st_no,t1.st_name from student t1,score t2 where t1.st_no=t2.sc_stno
and t2.sc_no=123
and t2.sc_sco>80

如果弯弯

a) update score set sc_sco=sc_sco+10 where sc_no='345';
b) select a.st_no,a.st_name from STUDENT a,score b
    where a.st_no = b.sc_stno and b.sc_no='123' and b.sc_sco>80;
c)select a.st_no,a.st_name ,a.st_age,b.sumsco
   from STUDENT a,(select sc_stno ,sum(sc_sco) as sumscore from score group by sc_stno) b
   where a.st_no=b.sc_stno;