select
    exp_type,
    round(
        avg(timestampdiff (minute, ec.out_time, ec.in_time)/60) * 1.0,
        1
    ) as time
from
    express_tb et
    join exp_action_tb ec using (exp_number)
group by
    exp_type
order by
    time