Simple Approach || Group By
IntuitionWe are trying to calculate the total work time for each employee on each day. By using the SUM function, we sum up the difference between out_time and
# Intuition
We are trying to calculate the total work time for each employee on each day. By using the SUM function, we sum up the difference between out_time and in_time for each employee (emp_id) for each event_day. This will give us the total working hours for every employee for every specific day.

# Approach
1. SUM(out_time - in_time): For each row, calculate the time worked as the difference between out_time and in_time. The SUM function will aggregate this time for each employee on each day.
2. GROUP BY day, emp_id: Group the results by event_day and emp_id to calculate the total time for each employee on each day.

# Code
```mysql []
# Write your MySQL query statement below
SELECT event_day AS 'day', emp_id,
SUM((out_time - in_time)) AS total_time
FROM Employees
GROUP BY day, emp_id
```
# PLEASE UPVOTE FOR MORE SUCH SOLUTIONS....
['MySQL']