#1741 Find Total Time Spent by Each Employee

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

MS SQL Server

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