[코드카타] SQL 26 Employee Bonus

Data_Student·2024년 11월 11일
0

코드카타

목록 보기
33/57

[코드카타] 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미만을 찾아서 추출하기!

0개의 댓글