create view v1 asselect student.sno,sname,avg(score) 平均成绩 from student join sc on student.sno=sc.sno group by student.sno,sname
usedb_tempgocreateviewview_employee1asselecttop2*fromemployee1
