리트코드(LeetCode) SQL 문제풀이 - 1741. Find Total Time Spent by Each Employee

2023. 1. 27. 15:51코딩테스트/리트코드(LeetCode) - SQL Study Plan

MySQL 문제 1741. Find Total Time Spent by Each Employee

select event_day as day,emp_id,SUM(out_time-in_time) as total_time
    from Employees
    group by emp_id,event_day;
728x90