41.declare @a numeric(5,2) set@a=(select avg(成绩)from Score) select from Score where成绩>=@a 42.create procedure xxkl as begin select from Students x,Score y where x,学号=y.学号 end 29541. declare @a numeric(5 ,2) set @a=(select avg( from Score) select from Score where 绩>=@a 42. create procedure xxkl as begin select from Students x ,Scor e y where x. 号=y. 学号 end 295