728x90
https://leetcode.com/problems/employee-bonus/
SELECT name, bonus
FROM Employee
LEFT JOIN Bonus
ON Employee.empId = Bonus.empId
WHERE bonus < 1000 OR bonus IS NULL;728x90
'IT > 코딩테스트' 카테고리의 다른 글
| [Leetcode] 88. Merge Sorted Array (1) | 2023.09.02 |
|---|---|
| [Leetcode] 1089. Duplicate Zeros (0) | 2023.09.02 |
| [Leetcode] 197. Rising Temperature (0) | 2023.08.31 |
| [Leetcode] 1581. Customer Who Visited but Did Not Make Any Transactions (0) | 2023.08.30 |
| [Leetcode] 1683. Invalid Tweets (0) | 2023.08.29 |