How many courses have more than 2 credits?
CREATE TABLE COURSE (Credits INTEGER)
SELECT COUNT(*) FROM COURSE WHERE Credits > 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE COURSE (Credits INTEGER) Question: How many courses have more than 2 credits? [/INST] SELECT COUNT(*) FROM COURSE WHERE Credits > 2 </s>