What are the dates of attendance for the student with id 141?
select date_of_attendance from student_course_attendance where student_id = 141
With id 171?
select date_of_attendance from student_course_attendance where student_id = 171
What are the courses that this student attends? Give the course names.
select course_name from courses as t1 join student_course_attendance as t2 on t1.course_id = t2.course_id where t2.student_id = 171
How many are there?
select count(*) from courses as t1 join student_course_attendance as t2 on t1.course_id = t2.course_id where t2.student_id = 171