[LeetCode/Easy] 1741. Find Total Time Spent by Each Employee

1. Input

1) Table: Employees (pk: (emp_id, event_day, in_time))

 

2. Output

1) 날짜 별로 emp_id가 일한 시간을 출력

- 일한 시간: out_time - in_time

- 출력 순서는 상관 없다.

 

3. Example

 

4. Code

1) 첫 코드(2023/04/17)

select event_day as day, emp_id, total_time
from (
    select event_day, emp_id, sum(out_time-in_time) as total_time
    from Employees
    group by event_day, emp_id
) e;