|
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 |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1795. Rearrange Products Table (0) | 2022.03.30 |
|---|---|
| leetcode 1587. Bank Account Summary II (0) | 2022.03.30 |
| leetcode 1693. Daily Leads and Partners (0) | 2022.03.29 |
| leetcode 1741. Find Total Time Spent by Each Employee (0) | 2022.03.29 |
| leetcode 1757. Recyclable and Low Fat Products (0) | 2022.03.29 |
댓글