simple sql solution
\nwith cte as(select event_day as day, emp_id, in_time,out_time, (out_time-in_time) diff\nfrom Employees\n            )\nselect day,emp_id, sum(diff) as total_t
```\nwith cte as(select event_day as day, emp_id, in_time,out_time, (out_time-in_time) diff\nfrom Employees\n            )\nselect day,emp_id, sum(diff) as total_time\nfrom cte\ngroup by 1,2\n```
[]