Find Total Time Spent by Each Employee.md

⚙문제보기

🔎문제 풀이 MySQL

SELECT event_day as 'day', emp_id, SUM(out_time - in_time) as 'total_time'
FROM Employees
GROUP BY event_day, emp_id