leetcode mysql题由简入深(未完持续)

---

181、Employees Earning More Than Their Managers（inner join，select嵌套）
select Employee from(select a.Name as Employee,a.Salary,b.Name as mName, b.Salary as mSalary from Employee a inner join Employee b on a.ManagerId=b.Id)as haha where Salary>mSalary;
select a.Name as Employee from Employee as a inner join Employee as b on a.ManagerId=b.Id where a.Salary>b.Salary;

答案2:
SELECT
a.Name AS ‘Employee’
FROM
Employee AS a,
Employee AS b
WHERE
a.ManagerId = b.Id
AND a.Salary > b.Salary
;

183、Customers Who Never Order（两个表join，null判断）
select Customers from(select a.Name as Customers,b.Id as order_id from Customers a left join Orders b on a.Id=b.CustomerId)as haha where order_id is null;
select a.Name as Customers from Customers as a where a.Id not in (select CustomerId from Orders);
596、Classes More Than 5 Students（去重，分组，group by having）
select class from (
select class, count(class) as num from(
select * from courses group by class,student
) as heihei group by class
) as haha where num>=5;
select class from(select * from courses group by student,class)as haha group by class having count(class)>=5;
197、Rising Temperature