Curam Software interview question

Some design patterns like factory pattern. some questions on SQL with an example. A simple algo: write an algorithm to count the no. of times each word is repeated in a string using hashmap.