题解 | 统计快递运输时长

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