#①找到经理的所有编号②让其与员工表内连接,然后分组筛选即可SELECT e1.name
FROM(SELECT id,name
FROM Employee
WHERE managerId ISNULLUNIONALLSELECT id,name
FROM Employee
WHERE id IN(SELECTdistinct managerId
FROM Employee
WHERE managerId ISNOTNULL))e1
INNERJOIN Employee e2
ON e1.id=e2.managerId
GROUPBY e1.name
HAVINGcount(*)>=5
1.3 运行截图
2 确认率
2.1 题目内容
2.1.1 基本题目信息1
2.1.2 基本题目信息2
2.1.3 示例输入输出
a 示例输入
b 示例输出
2.2 示例sql语句
SELECT s.user_id,ROUND(IFNULL(t.r,0),2) confirmation_rate
FROM Signups s
LEFTJOIN(SELECT user_id,SUM(IF(action='confirmed',1,0))/count(*) r
FROM Confirmations
GROUPBY user_id
)t
ON s.user_id=t.user_id
2.3 运行截图
3 有趣的电影
3.1 题目内容
3.1.1 基本题目信息
3.1.2 示例输入输出
3.2 示例sql语句
# Write your MySQL query statement belowSELECT id,movie,description,rating
FROM cinema
WHERE description <>'boring'ANDMOD(id,2)=1ORDERBY rating desc