LeetCode: Employee Bonus

LeetCode: Employee Bonus

Select all employee’s name and bonus whose bonus is < 1000.

Table:Employee

1
2
3
4
5
6
7
8
9
+-------+--------+-----------+--------+
| empId | name | supervisor| salary |
+-------+--------+-----------+--------+
| 1 | John | 3 | 1000 |
| 2 | Dan | 3 | 2000 |
| 3 | Brad | null | 4000 |
| 4 | Thomas | 3 | 4000 |
+-------+--------+-----------+--------+
empId is the primary key column for this table.

Table: Bonus

1
2
3
4
5
6
7
+-------+-------+
| empId | bonus |
+-------+-------+
| 2 | 500 |
| 4 | 2000 |
+-------+-------+
empId is the primary key column for this table.

Example ouput:

1
2
3
4
5
6
7
+-------+-------+
| name | bonus |
+-------+-------+
| John | null |
| Dan | 500 |
| Brad | null |
+-------+-------+

1
2
3
4
5
6
# 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;