题解 | 统计快递从创建订单到发出间隔时长
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
相关推荐