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

[LeetCode/SQL]

---

📌 1741. Find Total Time Spent by Each Employee

문제

풀이

- 일별, emp_id의 총 이용시간 구하기 

방법

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