Blog

Which of the following SELECT statements returns three colum…

Which of the following SELECT statements returns three columns from the Invoices table, named Number, Total and Balance where: Number: Column alias for the InvoiceNumber columnTotal: Column alias for the InvoiceTotal columnBalance: InvoiceTotal minus the PaymentTotal, minus the CreditTotal A. SELECT InvoiceNumber, InvoiceTotal, BalanceFROM Invoices;B.SELECT InvoiceNumber, InvoiceTotal, InvoiceTotal – PaymentTotal – CreditTotal AS Number, Total, BalanceFROM Invoices;C.SELECT InvoiceNumber AS Number, InvoiceTotal AS Total, InvoiceTotal + PaymentTotal + CreditTotal AS BalanceFROM Invoices;D.SELECT InvoiceNumber AS Number, InvoiceTotal AS Total,   InvoiceTotal – PaymentTotal – CreditTotal AS BalanceFROM Invoices;    

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;