LeetCode[MySQL] : Employees Earning More Than Their Managers

SOOYEON·2022년 3월 18일
0

SQL

목록 보기
8/54

Employees Earning More Than Their Managers

Q

# Write your MySQL query statement below
SELECT A.name AS 'Employee'
FROM Employee A JOIN Employee B ON A.managerId = B.id 
WHERE A.salary > B.salary

0개의 댓글