SELECT round(avg(timestampdiff(minute,b.create_time,a.out_time)/60),3) AS time FROM exp_action_tb AS a LEFT JOIN express_tb AS b ON a.exp_number=b.exp_number;
SELECT round(avg(timestampdiff(minute,b.create_time,a.out_time)/60),3) AS time FROM exp_action_tb AS a LEFT JOIN express_tb AS b ON a.exp_number=b.exp_number;