Infosys Interview Question

Query on join