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