Glassdoor Interview Question

Question related with self join in sql