with
t1 as(
select
avg(timestampdiff(minute,create_time,out_time)/60) as time
from
exp_action_tb left join express_tb using(exp_number)
)
select round(time,3) as time from t1

with
t1 as(
select
avg(timestampdiff(minute,create_time,out_time)/60) as time
from
exp_action_tb left join express_tb using(exp_number)
)
select round(time,3) as time from t1