SELECT k.miasto, SUM(z.kwota) AS suma_miasta FROM klienci k JOIN zamowienia z ON k.id_klienta = z.id_klienta GROUP BY k.miasto ORDER BY suma_miasta DESC;