[LeetCode] 1661. Average Time of Process per Machine (JOIN)

< 문제 >

[SQL50] 1661. Average Time of Process per Machine (JOIN)

---

---

< 풀이 >

WITH take_time AS(
    SELECT machine_id, process_id, SUM(CASE WHEN activity_type = 'start' THEN -1 * timestamp ELSE timestamp END)
    FROM Activity
    GROUP BY machine_id, process_id
)

SELECT machine_id, ROUND(AVG(sum) ::decimal, 3) AS processing_time
FROM take_time
GROUP BY machine_id;

---

WITH ~ AS( ... )

WITH AS로 임시 테이블 생성하여 활용

https://youngone-kang.tistory.com/45