What are all the different course titles?
select title from course
Of those, which are offered in more than one department?
select title from course group by title having count(*) > 1