CREATE TABLE student_course_registrations (course_Id VARCHAR2)
CREATE TABLE courses (course_name VARCHAR2, course_id VARCHAR2)

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
SELECT "T1"."course_name" FROM "courses" "T1" JOIN "student_course_registrations" "T2" ON "T1"."course_Id" = "T2"."course_Id" GROUP BY "T1"."course_Id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY