MySQL Simple and Clean Solution
Please Upvote if it helped you !!!\nHappy Coding :)\n\nselect event_day as day ,emp_id, sum(out_time) - sum(in_time) as total_time \nfrom employees \ngroup by e
**Please Upvote if it helped you !!!\nHappy Coding :)**\n```\nselect event_day as day ,emp_id, sum(out_time) - sum(in_time) as total_time \nfrom employees \ngroup by event_day,emp_id;\n```
['MySQL']