EXL Service Interview Question

One SQL question based on joins