how many courses did the student with id 121 register for?
SELECT count ( course_id )  FROM Student_Course_Registrations WHERE student_id  =  121
count of courses registered by a student = COUNT(course_id); student with id 121 refers to student_id = 121;