select exp_type
,round(avg(TIMESTAMPDIFF(MINUTE,t1.out_time,t1.in_time)/60),1) as time
from express_tb t
join exp_action_tb t1 on t.exp_number = t1.exp_number
group by exp_type
order by time