well, almost all the sql masters have answered the questions.

a simple group by and having count will serve the purpose.