update test4_05
set avg_score=(select test4_02.avg_score
from test4_02
where test4_02.sid=test4_05.sid)
update test4_05
set sum_credit=(select test4_03.sum_credit
from test4_03
where test4_03.sid=test4_05.sid)
update test4_05
set did=(select test04.did
from test04
where test04.dname=test4_05.dname)
where dname in (select dname
from test04)
update test4_05
set did='00'
where dname not in (select dname
from test04) or dname is null
update dbtest set test=4
select * from dbscore
6． 将pub用户下的Student_42及数据复制到主用户的表test4_06中,对表中的数据进
行整理，修复那些不规范的数据：
剔除姓名列中的所有空格；
select *from pub.student_42
drop table test4_06
create table test4_06 as select* from pub.student_42
update test4_06
set name=replace(name,' ','')
7． 将pub用户下的Student_42及数据复制到主用户的表test4_07中,对表中的数据进
行整理，修复那些不规范的数据：
对性别列进行规范（需要先确定哪些性别数据不规范，也就是那些和大多数不一样的就是不规范的）；
create table test4_07 as select* from pub.student_42
update test4_07
set sex=replace(sex,'性','')