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