Well Paid Employees

Well Paid Employees

문제

1. emplyee가 manger 보다 높은 급여를 받는 것 찾기

2. employee_id, name 출력

 

풀이

SELECT e1.employee_id, e1.name
FROM employee e1
left join employee e2 on e1.manager_id = e2.employee_id
where e1.salary > e2.salary

1️⃣ left join: 해당 employee에 맞는 manager_id 결합

2️⃣ where: empolyee의 salary와 manager의 salary 비교