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

简单多表连接