力扣sql简单篇练习(二十八)

力扣sql简单篇练习(二十八)

1 上级领导已离职的公司员工

1.1 题目内容

1.1.1 基本题目信息

1.1.2 示例输入输出

1.2 示例sql语句

# Write your MySQL query statement below
SELECT e1.employee_id
FROM
(
    SELECT employee_id,manager_id
    FROM Employees
    WHERE salary<=30000 AND manager_id is not null
)e1
LEFT JOIN Employees e2
ON e1.manager_id=e2.employee_id
WHERE e2.name is null
ORDER BY employee_id asc

1.3 运行截图

2 低质量的问题

2.1 基本题目内容

2.1.1 基本题目信息

2.1.2 示例输入输出

2.2 示例sql语句

# Write your MySQL query statement below
SELECT p.problem_id
FROM
(
    SELECT problem_id,likes/(likes+dislikes) rate
    FROM Problems
)p
WHERE p.rate<=0.6
ORDER BY problem_id asc

2.3 运行截图

3 赢得比赛的大学

3.1 题目内容

3.1.1 基本题目信息1

3.1.2 基本题目信息2

3.1.3 示例输入输出1

3.1.4 示例输入输出2

3.1.5 示例输入输出3

3.2 示例sql语句

# Write your MySQL query statement below
SELECT case
when t1.n1<t1.c1 then 'California University'
when t1.n1=t1.c1 then 'No Winner'
when t1.n1>t1.c1 then 'New York University'
end  winner
FROM
(
    SELECT
    (
        SELECT count(*)
        FROM NewYork
        WHERE score>=90
    )n1,
    (
        SELECT count(*)
        FROM California
        WHERE score>=90
    )c1
)t1

3.3 运行截图