Sql如何实现这样的效果

create table test ( VID int primary key, VNum int, vname varchar(10), score1 int, score2 int, score3 int ) select * from test insert into test values(1,001,'大海',20,30,40) insert into test values(2,001,'大海',30,40,50) insert into test values(3,001,'大海',40,50,60) 1，001，'大海'，45，60，75 也就是3个记录的平均分