题解 | 统计快递从创建订单到发出间隔时长
select
round(
avg(
timestampdiff (minute, create_time, out_time) / 60
),
3
) time
from
express_tb et
join exp_action_tb eat on et.exp_number = eat.exp_number
select
round(
avg(
timestampdiff (minute, create_time, out_time) / 60
),
3
) time
from
express_tb et
join exp_action_tb eat on et.exp_number = eat.exp_number
相关推荐