Write a SELECT statement that returns two columns from the I

Write a SELECT statement that returns two columns from the Invoices table: VendorID and PaymentSum, where PaymentSum is the sum of the PaymentTotal column. Group the result set by VendorID.

Solution

Select I.VendorID,Sum(I.PaymentTotal) as PaymentSum

from Invoices I

group by I.VendorID