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)
Kursları kaydettiren ancak kurslara katılmayan öğrencilerin tüm bilgileri nelerdir?