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

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