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.