use test
go

create function average(@cnum char(20)) returns int 
as
begin
    declare @aver int
    select @aver=
             (
               select avg(score)
                      from xs_kc
                      where course=@cnum
                         group by course
                  
                  )
    return @aver
end
go