MySQL Solution
Code\n\nselect\n    event_day as day, emp_id\n    , sum(out_time) - sum(in_time) as total_time\nfrom \n    Employees\ngroup by \n    event_day, emp_id\n
# Code\n```\nselect\n    event_day as day, emp_id\n    , sum(out_time) - sum(in_time) as total_time\nfrom \n    Employees\ngroup by \n    event_day, emp_id\n```
['Database', 'MySQL']