How many courses do the student whose id is 171 attend?
SELECT count(*) FROM courses AS T1 JOIN student_course_attendance AS T2 ON T1.course_id = T2.course_id WHERE T2.student_id = 171
number of courses attended by a specific student refers to COUNT(course_id); student identified by id = 171 refers to WHERE student_id = 171;