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

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT event_day AS 'day'
     , emp_id
     , SUM(out_time - in_time) AS total_time
FROM Employees
GROUP BY event_day, emp_id