In transact SQL

Write a SELECT statement that returns four columns: VendorName (from the Vendors table) Contact (a concatenated column with the firstinitial from the VendorContactFName in lowercase and VendorContactLName in all uppercase separatedby a space RealDate (InvoiceDate converted to regular format-i.e., Nov 18, 2013) InvoiceDollars (InvoiceTotal rounded so cents are not displayed-i.e., 107.00) Filter the results to only return records where a balance is due and sort the results by InvoiceDollars from largest to smallest.

Thank you in advance!