[코드카타] SQL 26 Employee Bonus

[코드카타] SQL 26 Employee Bonus

26. Employee Bonus
https://leetcode.com/problems/employee-bonus/

Write a solution to report the name and bonus amount of each employee 
with a bonus less than 1000.

select name, bonus
from employee e left join bonus b on e.empId=b.empId
where bonus is null or bonus < 1000

Left join을 통해 null값과 1000미만을 찾아서 추출하기!