Microsoft interview question

SQL Problem: The problem was about this Employee table in SQL with four columns: Name(string, PK), Alias(string, Unique), Phone(string, NULL), ManagerAlias(string, FK) I was asked about three different questions: 1. Finding an employee's manager 2. Finding a manager's employees 3. Finding the all employees under on manager