LeetCode Employees Earning More Than Their Managers解いてみた

問題

https://leetcode.com/problems/employees-earning-more-than-their-managers/submissions/

解いた

サブクエリを使えば良い。

SELECT
    name AS Employee
FROM
    Employee AS E
WHERE
    salary > (
        SELECT
            salary
        FROM
            Employee
        where
            id = E.managerId
    )
;

結果