题解 | 统计快递从创建订单到发出间隔时长
select
round(
avg(timestampdiff (minute, create_time, out_time)) / 60,
3
) as time
from
express_tb a,
exp_action_tb b
where
a.exp_number = b.exp_number
select
round(
avg(timestampdiff (minute, create_time, out_time)) / 60,
3
) as time
from
express_tb a,
exp_action_tb b
where
a.exp_number = b.exp_number
相关推荐
代码飞升_不回私信人...:很客观,两段实习中观察,感觉很多正式员工都很没生活,除了上班就是睡觉,时薪算下来也不是很高,有的糖人二级管居然觉得很正常,畸形成这样了都