LeetCode 刷题

577. 员工奖金【左连接： A left join B on...】

左连接后是一个新的表，后可以 + where 语句

# Write your MySQL query statement below
select name, bonus from Employee left join Bonus 
    on Employee.empId = Bonus.empId
    where bonus < 1000 or bonus is null;