Employee Bonus

Write a solution to report the name and bonus amount of each employee with a bonus less than 1000. Return the result table in any order.
문제링크

풀이

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