[LeetCode] 1661. Average Time of Process per Machine

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

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