SQL利用函数或存储过程求男或女的总分平均分

1--函数
2alter function xb
3(
4   @xingbie varchar(2) 
5   )
6returns table
7as
8return
9        ( select a.sex,SUM (b.score)as 总分,AVG(b.score)as 平均分
10         from stu3 as a full join stu4 as b on a .snum=b.cnum
11         where sex =@xingbie
12         group by a.sex
13         )
14go
15select * from xb ('女')
16
17--存储过程
18alter procedure xb1(@xingbie varchar(2))
19as
20        select a.sex,SUM (b.score)as 总分,AVG(b.score)as 平均分
21         from stu3 as a full join stu4 as b on a .snum=b.cnum
22         where sex =@xingbie
23         group by a.sex
24go
25exec xb1 '女'