List all names of courses with 1 credit?
CREATE TABLE COURSE (CName VARCHAR, Credits VARCHAR)
SELECT CName FROM COURSE WHERE Credits = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE COURSE (CName VARCHAR, Credits VARCHAR) Question: List all names of courses with 1 credit? [/INST] SELECT CName FROM COURSE WHERE Credits = 1 </s>