sql问题，找出选课女生最多的三门课的名字和选课女生的数量

SELECT subinfo.name,COUNT(*) AS girl_count         FROM Student_Info s JOIN Subject_Register sub         ON s.id=sub.student_id         JOIN Subject_Info subinfo         ON sub.subject_id=subinfo.id         WHERE s.gender=2         GROUP BY sub.subject_id         ORDER BY girl_count DESC         LIMIT 3 

leetcode1116

leetcode51