select
    exp_type,
    round(avg(timestampdiff (SECOND, out_time, in_time)/3600),1) as time 
from
    express_tb
    left join exp_action_tb using (exp_number)
group by
    exp_type
order by time asc