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