ONE LINE QUERY | BEGINNER LEVEL | MYSQL
One thing special is group by day and emp_id to make it ONE GROUP\n\n# Code\n\n# Write your MySQL query statement below\nselect event_day as day, emp_id, sum(ou
One thing special is group by day and emp_id to make it ONE GROUP\n\n# Code\n```\n# Write your MySQL query statement below\nselect event_day as day, emp_id, sum(out_time - in_time) as total_time from employees group by day, emp_id\n```
['MySQL']