577. 员工奖金
题目链接:577. 员工奖金
代码如下:
# Write your MySQL query statement below
select Employee.name,Bonus.bonus
from Employee left join Bonus on Employee.empId=Bonus.empId
where Bonus.bonus<1000 or Bonus.bonus is null
题目链接:577. 员工奖金
代码如下:
# Write your MySQL query statement below
select Employee.name,Bonus.bonus
from Employee left join Bonus on Employee.empId=Bonus.empId
where Bonus.bonus<1000 or Bonus.bonus is null