佬的项目能讲40分钟真的强啊! SELECT a.class AS '班级', SUM(b.score) AS '学生分数之和' FROM a JOIN b ON a.userid = b.userid GROUP BY a.class ORDER BY '学生分数之和' DESC;

相关推荐

牛客网
牛客企业服务