Blog

Which SQL SELECT statement correctly returns the Top 10 Vend…

Which SQL SELECT statement correctly returns the Top 10 Vendors that have the highest PaymentSum. The result table contains two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column? The result should is grouped by VendorName. The Invoices table is joined with the Vendors table. A.SELECT TOP 10 v.VendorName, SUM(i.PaymentTotal) AS PaymentSumFROM Vendors vJOIN Invoices i ON v.VendorID = i.VendorIDGROUP BY v.VendorNameORDER BY PaymentSum DESC;B.SELECT v.VendorName, SUM(i.PaymentTotal) AS PaymentSumFROM Vendors vJOIN Invoices i ON v.VendorID = i.VendorIDGROUP BY v.VendorNameORDER BY SUM(i.PaymentTotal) DESCLIMIT 10;C.SELECT TOP 10 v.VendorName, PaymentTotal AS PaymentSumFROM Vendors vJOIN Invoices i ON v.VendorID = i.VendorIDGROUP BY v.VendorNameORDER BY PaymentTotal DESC;