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
简单多表连接
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
简单多表连接