1661-average-time-of-process-per-machine

DevGod

Elf Vtuber

Caution

DevGod needs to write an editorial for this problem!

sql

# Write your MySQL query statement below

SELECT E.machine_id,
ROUND(AVG(E.timestamp-S.timestamp),3) AS processing_time
FROM Activity S
JOIN Activity E
ON S.machine_id = E.machine_id AND S.process_id = E.process_id
AND S.activity_type="start" AND E.activity_type = "end"
GROUP BY E.machine_id