What are the  ids of every student who has never attended a course?
SELECT student_id FROM students WHERE student_id NOT IN (SELECT student_id FROM student_course_attendance)
ids of every student who has never attended a course = student_id; students who have never attended a course refers to those not present in student_course_attendance;