what are their ids?
SELECT student_id FROM student_course_registrations GROUP BY student_id  having count ( * )   =  1
their ids refers to student_id of students; having count(*) = 1 implies students registered for exactly one course;