SELECT k.imie AS Klient, SUM(z.kwota) AS Suma FROM klienci k JOIN zamowienia z ON k.id_klienta = z.id_klienta GROUP BY k.imie;