编辑代码

CREATE PROCEDURE get_stu_avg_scorel
(stuno char(12),OUT grade FLOAT)
SELECT ROUND(AVG(choose.score),2) into
grade FROM choose WHERE student_id=stuno;
SET @avg_score=0;
call get_stu_avg_scorel
('201710201102',@avg_score);
SELECT @avg_score as 平均分;