LeetCode-数据库-2

584. 寻找用户推荐人

1
2
3
4
5
6
7
8
SELECT
name
FROM
Customer
WHERE
referee_id <> 2
OR
referee_id IS NULL

577. 员工奖金

1
2
3
4
5
6
7
8
9
10
11
SELECT
E.name,
B.bonus
FROM
Employee E
LEFT JOIN Bonus B
ON E.empId = B.empId
WHERE
B.bonus < 1000
OR
B.bonus IS NULL

570. 至少有5名直接下属的经理

1
2
3
4
5
6
7
8
9
10
SELECT 
E1.name
FROM
Employee E1
LEFT JOIN Employee E2
ON E1.id = E2.managerId
GROUP BY
E1.id
HAVING
COUNT(E1.id) >= 5
阅读更多