Pregunta de entrevista de Accenture

Difficult SQL join questions in Cognos BI interview.