1741.sql (123B)
1 SELECT event_day AS day, 2 emp_id, 3 SUM(out_time - in_time) AS total_time 4 FROM Employees 5 GROUP BY day, emp_id