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