# $577. 员工奖金
# https://leetcode-cn.com/problems/employee-bonus/

# SQL架构
Create table If Not Exists Employee (empId int, name varchar(255), supervisor int, salary int);
Create table If Not Exists Bonus (empId int, bonus int);
Truncate table Employee;
insert into Employee (empId, name, supervisor, salary) values ('3', 'Brad', null, '4000');
insert into Employee (empId, name, supervisor, salary) values ('1', 'John', '3', '1000');
insert into Employee (empId, name, supervisor, salary) values ('2', 'Dan', '3', '2000');
insert into Employee (empId, name, supervisor, salary) values ('4', 'Thomas', '3', '4000');
Truncate table Bonus;
insert into Bonus (empId, bonus) values ('2', '500');
insert into Bonus (empId, bonus) values ('4', '2000');

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

# clean-up
drop table Employee;
drop table Bonus;