文章目录
题目
代码(7.15 首刷看解析)
# Write your MySQL query statement below
select a1.machine_id machine_id, round(avg(a2.timestamp - a1.timestamp), 3) processing_time from Activity a1 inner join Activity a2
on a1.machine_id = a2.machine_id
and a1.process_id = a2.process_id
and a1.activity_type = 'start' and a2.activity_type = 'end'
group by machine_id