Which students didn't attend courses?
select * from student_course_registrations where student_id not in ( select student_id from student_course_attendance )
How about student that did attend courses?
select * from student_course_registrations where student_id in ( select student_id from student_course_attendance )
Registration date
select registration_date from student_course_registrations