Find the names of courses that have either 3 credits or 1 credit but 4 hours.
CREATE TABLE COURSE (CName VARCHAR, Credits VARCHAR, Hours VARCHAR)
SELECT CName FROM COURSE WHERE Credits = 3 UNION SELECT CName FROM COURSE WHERE Credits = 1 AND Hours = 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE COURSE (CName VARCHAR, Credits VARCHAR, Hours VARCHAR) Question: Find the names of courses that have either 3 credits or 1 credit but 4 hours. [/INST] SELECT CName FROM COURSE WHERE Credits = 3 UNION SELECT CName FROM COURSE WHERE Credits = 1 AND Hours = 4 </s>