Find courses that ran in Fall 2009 or in Spring 2010.
CREATE TABLE SECTION (course_id VARCHAR, semester VARCHAR, YEAR VARCHAR)
SELECT course_id FROM SECTION WHERE semester = 'Fall' AND YEAR = 2009 UNION SELECT course_id FROM SECTION WHERE semester = 'Spring' AND YEAR = 2010
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE SECTION (course_id VARCHAR, semester VARCHAR, YEAR VARCHAR) Question: Find courses that ran in Fall 2009 or in Spring 2010. [/INST] SELECT course_id FROM SECTION WHERE semester = 'Fall' AND YEAR = 2009 UNION SELECT course_id FROM SECTION WHERE semester = 'Spring' AND YEAR = 2010 </s>