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