题：请计算出每个开发者解决bug的反应周期（即bug的解决周期，从bug产生到解决的时间的平均值）。
#计算bug生存周期,方法一： select resolvedBy ,format (avg(MM),1) as 'bug生存期(天)' from ( SELECT `resolvedBy` ,(to_days(`resolvedDate` )- to_days(`openedDate` )) MM FROM `zt_bug`) SS group by resolvedBy #计算bug生存周期,方法二： select resolvedBy ,format(avg(to_days(`resolvedDate` )- to_days(`openedDate` )) ,1) as 'bug生存期(天)' from `zt_bug` group by resolvedBy
转载请注明原文地址: https://ju.6miu.com/read-2162.html
