DQL
#子查询
SELECT courseId,AVG(result) FROM score GROUP BY courseId
ORDER BY AVG(result) DESC LIMIT 1;
#父子联合查询
SELECT * FROM courseName'科目名称',department'所属院系',number'课程总人数' FROM course where id (
SELECT courseId form score GROUP BY courseId
ORDER BY AVG(result) DESC LIMIT 1
);