Xoriant interview question

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