2025-08-15 10:38:16 +0000 UTC

Find Total Time Spent by Each Employee
Categories:
Tags:

Code

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