Temenos interview question

Based on Joins Only