Xinno interview question

Join Query of 3 table