Write an SQL query to report the name and bonus amount of each employee with a bonus less than 1000.
Return the result table in any order.
table name: Employee
table name: Bonus
Input:
Expected Output:
Solution:
select e.name, b.bonus from employee as e
left join bonus as b on e.empId = b.empId
where b.bonus<1000 or b.bonus is null
Output:
SQL Script:
Create table Employee (empId int, name varchar(255), supervisor int, salary int)
Create table Bonus (empId int, bonus int)
insert into Employee (empId, name, salary) values ('3', 'Brad', '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')
insert into Bonus (empId, bonus) values ('2', '500')
insert into Bonus (empId, bonus) values ('4', '2000')