How many different courses offered by Physics department?
SELECT count(DISTINCT course_id) FROM course WHERE dept_name  =  'Physics'
different courses offered by a department refers to COUNT(DISTINCT course_id); by Physics department refers to dept_name = 'Physics';