Who are the students? Give the id and details.
select student_id, student_details from students
Which students attend courses?
select student_id, student_details from students where student_id in (select student_id from student_course_attendance)
Which ones do not? Just give the student id.
select student_id from students where student_id not in (select student_id from student_course_attendance)