select exp_type,round(avg(timestampdiff(minute,out_time,in_time)/60),1) time from express_tb e1 join exp_action_tb e2 on e1.exp_number = e2.exp_number group by exp_type order by time