1741. Find Total Time Spent by Each Employee

SQL

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