SQL/문제풀이

Employee Bonus _ Easy. leetcode

데이터분석가 이채은 2024. 9. 28. 09:00

 

Solution

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