Question

Write a SELECT statement that returns four columns from the Invoices table, named Number, Total, Credits, and Balance: Number Column alias for the InvoiceNumber column Total Column alias for the InvoiceTotal column Credits Sum of the PaymentTotal and CreditTotal columns Balance InvoiceTotal minus the sum of PaymentTotal and CreditTotal Use the AS keyword to assign column aliases.

Answer 1

Answer and Explanation:

For returning four columns from the Invoices table, named Number, Total, Credits, and Balance the SELECt statement is as follows

Select Invoice Number As Number

Invoice Total As Total

Payment total + credit total As Credits

Invoice total

(Payment total + credit total) As Balance

These are displayed as above