Guidewire interview question

fibonacci sequence, recursion, pattern creation, inner join, difference between having and where clause, etc