题解 | 统计快递运输时长
统计快递运输时长
https://www.nowcoder.com/practice/bb4196936f15424dbabe76a501186d91
select
exp_type,
round(avg(timestampdiff (SECOND, out_time, in_time)/3600),1) as time
from
express_tb
left join exp_action_tb using (exp_number)
group by
exp_type
order by time asc
查看3道真题和解析