What are all info of students who registered courses but not attended courses?
SELECT * FROM student_course_registrations WHERE student_id NOT IN (SELECT student_id FROM student_course_attendance)
students who registered for courses but did not attend refers to student_id in student_course_registrations but not in student_course_attendance; all info refers to SELECT *;