select round(avg(timestampdiff(minute,e.create_time,ea.out_time))/60,3) as time from express_tb e join exp_action_tb ea on e.exp_number = ea.exp_number
简单
select round(avg(timestampdiff(minute,e.create_time,ea.out_time))/60,3) as time from express_tb e join exp_action_tb ea on e.exp_number = ea.exp_number
简单