select
    exp_type,
    round(avg(timestampdiff(second,out_time,in_time)/3600),1) as time
from
    express_tb tb1
    left join exp_action_tb tb2 on tb1.exp_number = tb2.exp_number    
group by
    exp_type
order by 
    time