https://leetcode.com/problems/employee-bonus/description/
Employee Bonus - LeetCode
Can you solve this real interview question? Employee Bonus - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
|
1
2
3
4
5
6
|
# Write your MySQL query statement below
select e.name, b.bonus
from Employee e
left join Bonus b
on e.empId = b.empId
where b.bonus <1000 or b.bonus is null
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1068. Product Sales Analysis I (0) | 2023.04.14 |
|---|---|
| leetcode 1280. Students and Examinations (0) | 2023.04.12 |
| leetcode 1327. List the Products Ordered in a Period (0) | 2023.04.08 |
| leetcode 1789. Primary Department for Each Employee (0) | 2023.04.08 |
| leetcode 1251. Average Selling Price (0) | 2023.04.07 |
댓글