SELECT Nume, SUM(Suma) FROM Vanzari LEFT JOIN Clienti GROUP BY Nume;

SELECT C.Nume, SUM(V.Suma) FROM Vanzari V JOIN Clienti C ON V.ID_Client = C.ID_Client GROUP BY C.Nume;

SELECT SUM(Suma), Nume FROM Clienti JOIN Vanzari GROUP BY Nume;