在mysql中怎样设计一个存储过程，根据"学号"返回成绩表中平均成绩在60分以上的学生的学分

drop procedure if exists type

delimiter $

create procedure type(

in shuruxuehao VARCHAR(20),

out shuchuxuefen int(11)

)

BEGIN

set shuchuxuefen = 0

set @num = 0

set @xuefen = 0

select sum(chengji1 +chengji2 + ... + chengjiN )/ n as num,xuefen into

@num, @xuefen from table where xuehao = shuruxuehao/*chengji 是各科成绩的字段*/

if num >=60 then

set shuchuxuefen = @xuefen

else

set shuchuxuefen = 0

end if

END

$

delimiter

<pre t="code" l="sql">select 班级字段,count(1) from 表名 where 成绩字段 >60 group by 班级字段用这条语句就行

---