SELECT count(DISTINCT course_id) FROM course WHERE dept_name  =  'Physics'
How many different courses offered by Physics department?
SELECT count ( DISTINCT course_id ) FROM course WHERE dept_name = 'Physics '
select count ( distinct course_id ) from course where dept_name = value
How many different courses offered by Physics department ?