What are the id of students who registered courses or attended courses?
CREATE TABLE student_course_attendance (student_id VARCHAR); CREATE TABLE student_course_registrations (student_id VARCHAR)
SELECT student_id FROM student_course_registrations UNION SELECT student_id FROM student_course_attendance
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE student_course_attendance (student_id VARCHAR); CREATE TABLE student_course_registrations (student_id VARCHAR) Question: What are the id of students who registered courses or attended courses? [/INST] SELECT student_id FROM student_course_registrations UNION SELECT student_id FROM student_course_attendance </s>