select destination_city,transport_name,round(avg(delivery_date-order_Date),2) as average_transport_duration,round(sum(total_cost),2) as total_transport_cost

from order_info 
join transport_detail using(transport_id)
join cost_data using(order_id)
group by transport_name,destination_city
order by destination_city asc,transport_name asc