Guidewire interview question

code test on sql query , bug fix and code challenge