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)