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;
Read Details