Employee Bonus

Task: Report the name and bonus amount of each employee with a bonus less than 1000.

Table: Employee

+-------------+--------------+
| Column Name | Type         |
+-------------+--------------+
| empId       | INT          |
| name        | varchar(255) |
| supervisor  | INT          |
| salary      | INT          |
+-------------+--------------+

Table: Bonus

+-------------+------+
| Column Name | Type |
+-------------+------+
| empId       | INT  |
| bonus       | INT  |
+-------------+------+

Input: Employee table:

+-------+--------+------------+--------+
| empId | name   | supervisor | salary |
+-------+--------+------------+--------+
| 3     | Brad   | null       | 4000   |
| 1     | John   | 3          | 1000   |
| 2     | Dan    | 3          | 2000   |
| 4     | Thomas | 3          | 4000   |
+-------+--------+------------+--------+

Bonus table:

+-------+-------+
| empId | bonus |
+-------+-------+
| 2     | 500   |
| 4     | 2000  |
+-------+-------+

Output:

+------+-------+
| name | bonus |
+------+-------+
| Brad | null  |
| John | null  |
| Dan  | 500   |
+------+-------+