which course has most number of registered students ?
SELECT T1.course_name FROM courses AS T1 JOIN student_course_registrations AS T2 ON T1.course_id  =  T2.course_Id GROUP BY T1.course_id ORDER BY count ( * )  DESC LIMIT 1
most number of registered students refers to MAX(COUNT(student_id));