HCLTech interview question

queries on join