1741-Find-Total-Time-Spent-By-Each-Employee.sql

-- 1741-Find-Total-Time-Spent-By-Each-Employee
-- Exercise from: https://leetcode.com/problems/find-total-time-spent-by-each-employee/
SELECT
    event_day AS day,
    emp_id,
    SUM(out_time - in_time) AS total_time
FROM
    Employees
GROUP BY
    emp_id,
    event_day