题解 | 统计快递运输时长
select
exp_type,
round(
avg(timestampdiff (minute, out_time, in_time)) / 60,
1
) time
from
test.express_tb et
join test.exp_action_tb eat on et.exp_number = eat.exp_number
group by
exp_type
order by
time
查看8道真题和解析