[LeetCode] 577. Employee Bonus

단간단간·2024년 4월 2일

SQL 문제

목록 보기
10/12

문제 링크:
https://leetcode.com/problems/employee-bonus/description/?envType=study-plan-v2&envId=top-sql-50

MySQl

SELECT 
    A.name, 
    B.bonus
FROM 
    Employee A
    LEFT JOIN Bonus B ON B.empID = A.empID
WHERE 
    B.bonus < 1000
    OR B.bonus IS NULL;
profile
simple is best

0개의 댓글