how many students registered for just one course
SELECT COUNT ( * )  FROM  ( SELECT student_id FROM student_course_registrations GROUP BY student_id  having count ( * )   =  1 ) 
students registered for just one course refers to COUNT(student_id) WHERE the COUNT of courses per student_id = 1;