select
exp_type,
round(avg(exp_time)/60,1) as time
from (
select
exp_number,
exp_type,
timestampdiff(minute,out_time,in_time) as exp_time
from express_tb
join exp_action_tb using(exp_number)
) as u1
group by exp_type
order by time

京公网安备 11010502036488号