https://leetcode.com/problems/calculate-special-bonus/
Calculate Special Bonus - LeetCode
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
# Write your MySQL query statement below
select employee_id,
if (employee_id%2 = 1 and name not like 'M%', salary, 0) as bonus
from Employees728x90
반응형
'자료구조 알고리즘 > 코딩테스트' 카테고리의 다른 글
| 196. Delete Duplicate Emails (0) | 2022.05.30 |
|---|---|
| 627. Swap Salary (0) | 2022.05.30 |
| 1137. N-th Tribonacci Number (0) | 2022.05.27 |
| 509. Fibonacci Number (0) | 2022.05.27 |
| [MySQL] left join, left outer join (0) | 2022.05.27 |
