Glassdoor interview question

Question related with self join in sql