Pregunta de entrevista de Glassdoor

Question related with self join in sql