문제
입력 코드
SELECT E.name, B.bonus
FROM Employee AS E
LEFT JOIN Bonus AS B
USING (empID)
WHERE (B.bonus < 1000)
OR (B.bonus IS NULL)
코드 설명
#SELECT #LEFT JOIN #JOIN #USING #WHERE #NULL
문제 출처
Employee Bonus - LeetCode
Can you solve this real interview question? Employee Bonus - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | empId | int | | name | varchar | | supervisor | int | | salary | int | +-------------+---------+ empId
leetcode.com