Write a SELECT statement that returns two columns: vendor_id and the largest unpaid invoice for each vendor. To do this, you can group the result set by the vendor_id column. This should return 7 rows. Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return a single value that represents the sum of the largest unpaid invoices for each vendor\.\*/

1. SELECT VendorID, MAX(InvoiceTotal) AS InvoiceMax

     FROM Invoices

     WHERE InvoiceTotal - CreditTotal - PaymentTotal > 0

     GROUP BY VendorID

2. SELECT SUM(InvoiceMax) AS SumOfMaximums

FROM (SELECT VendorID, MAX(InvoiceTotal) AS InvoiceMax

     FROM Invoices

     WHERE InvoiceTotal - CreditTotal - PaymentTotal > 0

     GROUP BY VendorID) AS MaxInvoice

solution:

the auto-correct option of the auto-correct tool enables you to add and delete words that do not follow abbreviation rules because:

it is a feature that allows outlook to correct common spelling and typing errors and to replace characters with symbols. we can also can use auto-correct as a shortcut, which means we can type a small string of characters and have those characters replaced by a longer string.