山东大学数据库实验4答案.docVIP

山东大学数据库实验4答案 update dbtest set test=4 select * from dbscore 实验一: create table test4_01 as ( select * from pub.student_41 ) alter table test4_01 add sum_score decimal alter table test4_01 add avg_score decimal(4,1) alter table test4_01 add sum_credit decimal alter table test4_01 add did varchar(2) update test4_01 set sum_score = ( select sum(a.score) from pub.student_course a,pub.course b where a.cid=b.cid and a.sid=test4_01.sid group by a.sid ) 实验二 create table test4_02 as ( select * from pub.student_41 ) alter table test4_02 add sum_score decimal alter table test4_02 add avg_score decimal(4,1