用mysql的exists查询选课人数最多的课程名

可以使用以下SQL语句查询选课人数最多的课程名：

SELECT course_name FROM course
WHERE EXISTS (
SELECT 1 FROM student_course
WHERE student_course.course_id = course.course_id
GROUP BY course_id
HAVING COUNT(*) = (
SELECT MAX(student_count)
FROM (
SELECT COUNT(*) as student_count
FROM student_course
GROUP BY course_id
) AS counts
)
);