EXL Service interview question

One SQL question based on joins