Task: Text to Code
Input (English): What are all info of students who registered courses but not attended courses?
Output (English): SELECT * FROM student_course_registrations WHERE student_id NOT IN (SELECT student_id FROM student_course_attendance)