README.md

577. 员工奖金

English Version

题目描述

None

解法

SQL

SELECT name,
         bonus
FROM Employee e
LEFT JOIN Bonus b
    ON e.empId = b.empId
WHERE (b.bonus < 1000
        OR b.bonus is null)