Domanda di colloquio di Xoriant

Query was asked on self join with nested query on sql?