리트코드(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
'코딩테스트 > 리트코드(LeetCode) - SQL Study Plan' 카테고리의 다른 글
리트코드(LeetCode) SQL 문제풀이 - 1407. Top Travellers (0) | 2023.01.27 |
---|---|
리트코드(LeetCode) SQL 문제풀이 - 1393. Capital Gain/Loss (0) | 2023.01.27 |
리트코드(LeetCode) SQL 문제풀이 - 1890. The Latest Login in 2020 (0) | 2023.01.26 |
리트코드(LeetCode) SQL 문제풀이 - 511. Game Play Analysis I (0) | 2023.01.26 |
리트코드(LeetCode) SQL 문제풀이 - 586. Customer Placing the Largest Number of Orders (0) | 2023.01.26 |