SELECT title FROM course GROUP BY title HAVING count(*)  >  1
What are the titles of courses that are offered in more than one department?
SELECT title FROM course GROUP BY title HAVING count ( * ) > 1
select title from course group by title having count ( * ) > value
What are the titles of courses that are offered in more than one department ?