SQL

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