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


京公网安备 11010502036488号