|
1
2
3
4
5
|
/* Write your PL/SQL query statement below */
select TO_CHAR(event_day, 'YYYY-MM-DD') as day, emp_id, sum(out_time - in_time) as total_time
from Employees
group by event_day, emp_id
order by 1, 2, 3
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1873. Calculate Special Bonus (0) | 2022.03.29 |
|---|---|
| leetcode 1693. Daily Leads and Partners (0) | 2022.03.29 |
| leetcode 1757. Recyclable and Low Fat Products (0) | 2022.03.29 |
| hacker rank The Report (0) | 2022.03.29 |
| Hacker Rank Top Competitors (0) | 2022.03.29 |
댓글