SHL Global interview question

join between three tables