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