Oracle Simple and Fastest Solution
\n/* Write your PL/SQL query statement below */\n\nSELECT \nTO_CHAR(event_day, \'YYYY-MM-DD\') AS "day", \nemp_id, \nSUM(out_time) - SUM(in_time) AS "total_time
```\n/* Write your PL/SQL query statement below */\n\nSELECT \nTO_CHAR(event_day, \'YYYY-MM-DD\') AS "day", \nemp_id, \nSUM(out_time) - SUM(in_time) AS "total_time" \nFROM employees \nGROUP BY event_day, emp_id \nORDER BY "total_time" DESC;\n```
['MySQL', 'Oracle']