1741. Find Total Time Spent by Each Employee

https://leetcode.com/problems/find-total-time-spent-by-each-employee/

Find Total Time Spent by Each Employee - LeetCode

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