leetcode 577. 员工奖金

577. 员工奖金 - 力扣（LeetCode） 建立左外连接然后选出bonus < 100 or bonus is null的数据

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;