Accenture Interview Question

Q SQL joins related query