现在有一个工厂网站由几台机器运行,每台机器上运行着 相同数量的进程 。编写解决方案,计算每台机器各自完成一个进程任务的平均耗时。
select machine_id,
round(sum(if(activity_type='end', timestamp, -timestamp)) / count(distinct process_id), 3) as processing_time
from Activity
group by machine_id
现在有一个工厂网站由几台机器运行,每台机器上运行着 相同数量的进程 。编写解决方案,计算每台机器各自完成一个进程任务的平均耗时。
select machine_id,
round(sum(if(activity_type='end', timestamp, -timestamp)) / count(distinct process_id), 3) as processing_time
from Activity
group by machine_id