文章目录
-
- 原题题目
- 代码实现(首刷自解)
原题题目
代码实现(首刷自解)
# Write your MySQL query statement below
SELECT event_day day,emp_id,(SUM(out_time) - SUM(in_time)) total_time
FROM employees
GROUP BY emp_id,event_day
# Write your MySQL query statement below
SELECT event_day day,emp_id,(SUM(out_time) - SUM(in_time)) total_time
FROM employees
GROUP BY emp_id,event_day