SQL
leetcode 1873. Calculate Special Bonus
무적김두칠
2022. 3. 29. 17:16
1
2
3
4
5
|
/* Write your PL/SQL query statement below */
select
employee_id
,case when mod(employee_id, 2)=1 and substr(name,1,1)!='M' then salary else 0 end as bonus
from employees;
|
cs |
반응형