LeetCode精选数据库70题题解

577-员工奖金

577. 员工奖金

1
2
3
4
5
6
# Write your MySQL query statement below
select name, bonus
from employee e
  left join bonus b 
  on e.empId = b.empId
where b.bonus is null or b.bonus < 1000;