How many different courses offered by Physics department?
CREATE TABLE course (course_id VARCHAR, dept_name VARCHAR)
SELECT COUNT(DISTINCT course_id) FROM course WHERE dept_name = 'Physics'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE course (course_id VARCHAR, dept_name VARCHAR) Question: How many different courses offered by Physics department? [/INST] SELECT COUNT(DISTINCT course_id) FROM course WHERE dept_name = 'Physics' </s>