What are all the courses in the Physics department?
select * from course where dept_name = 'Physics'
What are their course ids?
select distinct course_id from course where dept_name = 'Physics'
How many are there?
select count(distinct course_id) from course where dept_name = 'Physics'