Infosys Interview Question

Join query in sql