select user_name,avg (score) from score s join user u on u.user_id = s.user_id join subject su on su.subject_id = s.subject_id where u.user_id=#{userId}
求个人的平均分
最新推荐文章于 2021-12-15 23:36:25 发布
select user_name,avg (score) from score s join user u on u.user_id = s.user_id join subject su on su.subject_id = s.subject_id where u.user_id=#{userId}