181. Employees Earning More Than Their Managers解题

 
题目分析：
雇员表有所有员工的信息。所有员工和经理都有ID。给定雇员表，通过编写SQL找到工资比经理多的员工的姓名。上表中，只有Joe工资比经理多。此题采用自连接


SQL语句：
SELECT a.NAME FROM Employee a, Employee b 
WHERE a.ManagerId = b.Id AND a.Salary > b.Salary;