Tag: 1661. Average Time of Process per Machine

1661. Average Time of Process per Machine SQL Code: SELECT machine_id, ROUND(AVG(end_time – start_time), 3) AS processing_time FROM ( SELECT machine_id, process_id, MAX(CASE WHEN activity_type = 'end' THEN timestamp END) AS end_time, MAX(CASE WHEN activity_type = 'start' THEN timestamp END) AS start_time FROM Activity GROUP BY machine_id, process_id ) AS…