select city
,round(sum(total_amount),2) as 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