mysql存储过程求平均成绩的语句怎么写啊？我的table 的名字是 t 。我建一procedure p1()，call p1() 如下

mysql> call p1()//
+--------+-------+------------+------+-------+--------+--------+
| number | name | birth | sex | yuwen | shuxue | yingyu |
+--------+-------+------------+------+-------+--------+--------+
| 200801 | wang | 1980-01-01 | M | 85 | 85 | 90 |
| 200802 | zhang | 1980-11-02 | W | 90 | 80 | 90 |
| 200803 | luo | 1980-03-12 | W | 90 | 95 | 100 |
| 200804 | yang | 1981-05-22 | M | 90 | 80 | 70 |
| 200805 | li | 1979-10-04 | W | 90 | 85 | 95 |
+--------+-------+------------+------+-------+--------+--------+

直接用sql就好了，如果是每个学生的平均成绩
select number, name, birth, sex, (yuwen+shuxue+yingyu)/3 as average from t

如果是全部的平均成绩：
select avg(yuwen) as yuwen, avg(shuxue) as shuxue, avg(yingyu) as yingyu from t

我。。知。。道 加。。我。。私。。聊