Accenture interview question

Q SQL joins related query