select student_id,avg(score),max(score),min(score) from t_score GROUP BY student_id
select t.name,avg(c.score),max(c.score),min(c.score) from t_score c right join t_student t GROUP BY t.student_id，c.item_id
