Database: student_assessment
Question: How many courses does the student with id 171 actually attend?
SQL:
SELECT count(*) FROM courses AS T1 JOIN student_course_attendance AS T2 ON T1.course_id = T2.course_id WHERE T2.student_id = 171