select round(avg(timestampdiff(MINUTE,create_time,out_time)/60 ) ,3) as time
from(
select t1.create_time, t2.out_time
from express_tb t1
left join exp_action_tb t2
on t1.exp_number = t2.exp_number
) t3