上面红字MySQL该求科普怎么写

Question

Answer 1

不知道表名称和列名称，大概写一下,查出来就是1条记录，一个是成绩，一个是课名。

SELECT TOP 1 * FROM (
SELECT SUM(X.成绩) AS CJ,K.课程名 AS KM FROM 课程表 AS K INNER JOIN 选课表 AS X ON K.课程号=X.课程号  GROUP BY  K.课程名) T ORDER BY CJ ASC