Question d’entretien chez Xoriant

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