qq_43584975的博客

成绩表userid 学生姓名，kechengid课程，category1id班级,semesterid学期学生表求某一学期，某个班的成绩排名select nickname,sum(score) from student left join achievement on achievement.userid=student.id group by achievement.userid where student.category1id=13 and semesterid=4;...