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}
求个人的平均分
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}
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
