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