What are the ids of the students who either registered or attended a course?
SELECT student_id FROM student_course_registrations UNION SELECT student_id FROM student_course_attendance
ids of the students who registered for a course refers to student_id in student_course_registrations; ids of the students who attended a course refers to student_id in student_course_attendance;