Accenture interview question

Difficult SQL join questions in Cognos BI interview.