select city,sum(total_amount) total_order_amount
from orders o join customers c on o.customer_id = c.customer_id
group by city
order by total_order_amount desc , city