[LeetCode] 577. Employee Bonus (JOIN)

< 문제 >

[SQL50] 577. Employee Bonus (JOIN)

---

 

---

< 풀이 >

SELECT A.name, B.bonus
FROM Employee A LEFT JOIN Bonus B ON A.empId = B.empId
WHERE bonus < 1000 OR bonus IS NULL;