Database: student_assessment
Question: What are all details of the students who registered but did not attend any course?
SQL:
SELECT * FROM student_course_registrations WHERE student_id NOT IN (SELECT student_id FROM student_course_attendance)