SELECT ROUND(AVG(TIMESTAMPDIFF(minute,e.create_time,ea.out_time))/60,3) AS time FROM express_tb AS e INNER JOIN exp_action_tb AS ea ON e.exp_number=ea.exp_number;