修改学生姓名是赵成刚的视图“view-sp”，为视图指定列明

更新时间2018-12-25 00:42:32

create view view2(sno,savg,sname)as select Student.Sno,Sname,AVG((cast(StudentCourse.Grade as int)))from Student join StudentCourseon StudentCourse.Sno=Student.Snogroup by Student.Sno,Student.Sname即可，反正Sno已经保证唯一了，再加上Sname也无法再干扰什么了。