题解 | 查询出每个运输方式在不同城市的平均运输时长以及总运输费用
查询出每个运输方式在不同城市的平均运输时长以及总运输费用
https://www.nowcoder.com/practice/673bf7b17e7c4962bcde889980eec872
select
destination_city,
transport_name,
round( avg(timestampdiff(day,order_date,delivery_date )),2) as average_transport_duration,
round(sum(total_cost ),2) as total_transport_cost
from transport_detail join order_info using(transport_id )
join cost_data using(order_id )
group by transport_name,destination_city
order by destination_city,transport_name;
