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 event_day, emp_id;