SQL 문제 28 - Find Total Time Spent by Each Employee LeetCode 1741

SQL 문제 28 - Find Total Time Spent by Each Employee LeetCode 1741 Find Total Time Spent by Each Employee 풀이 -- ORACLE SELECT TO_CHAR(EVENT_DAY,'YYYY-MM-DD') AS DAY , EMP_ID , SUM(OUT_TIME) - SUM(IN_TIME) AS TOTAL_TIME FROM EMPLOYEES GROUP BY EVENT_DAY, EMP_ID ORDER BY EVENT_DAY ASC; -- MYSQL, MSSQL SELECT EVENT_DAY AS DAY , EMP_ID , SUM(OUT_TIME) - SUM(IN_TIME) AS TOTAL_TIME FROM EMPLOYEES GROUP BY EVENT_DAY, EMP_ID ORDER BY EVENT_DAY ASC; * 출처 Level up your coding skills and quickly land a job. ...