A. Write a query that returns the total Invoice Total for each vendor id. Sort the results by vendor id.

B. Write a query that returns the vendor name, the count of invoices per vendor and the sum of Invoice Total. Sort the results by payment total in descending order.

C. Write a query that returns the vendor name, the count of invoices for each vendor, and the sum of invoice total. Sort the results by invoice count descending.

D. Write a query that returns for each general ledger account, the account description, the count of entries for each account, and the sum of line item amounts. Include the results with a count of accounts of more than one

E GENERAL_LEDGER_ACCOUNTS ACCOUNTDESCRIPTION - INVOICE DUE-DATE E..E INVOICE-LINE ITEMS DESCRIPTION INVOICE-DATE INVOICEDUEDATE PAYMENTDATE - - - nwnwnw