بنخلي الكود يبقى مفهوم.

SELECT s.name, COUNT(e.id) AS enrolments
FROM students s
LEFT JOIN enrolments e ON e.student_id = s.id
GROUP BY s.name
ORDER BY enrolments DESC, s.name;