Database: college_2
Question: Count the number of courses in the Physics department.
SQL:
SELECT count(DISTINCT course_id) FROM course WHERE dept_name  =  'Physics'