Write a SELECT statement that returns one column from the Vendors table named Full Name. Create this column from the VendorContactFName and VendorContactLName columns. Format it as follows: last name, comma, first name $($for example, $$Doe$,$ John$).$ Sort the result set by last name, then by first name. $(10$ points$)$

$4.$

Write a SELECT statement that returns three columns:

InvoiceTotal From the Invoices table

$10\%10\%$ of the value of InvoiceTotal

Plus $10\%$ The value of InvoiceTotal plus $10\%$

$($For example, if InvoiceTotal is $100,10\%$ is $10,$ and Plus $10\%$ is $110.)$ Only return those rows with a balance due greater than $1000.$ Sort the result set by InvoiceTotal, with the largest invoice first.