Database: student_assessment
Question: What are all info of students who registered courses but not attended courses?
SQL:
SELECT * FROM student_course_registrations WHERE student_id NOT IN (SELECT student_id FROM student_course_attendance)