[LeetCode] 577. Employee Bonus

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT e.name
     , b.bonus
FROM Employee AS e
    LEFT JOIN Bonus AS b ON e.empId = b.empId
WHERE b.bonus < 1000
   OR b.bonus IS NULL