Demonstrate mastery of Aggregate functions, grouping, and SQL joins.

/* Use the Murach AP database to produce the requested result sets. 1. Produce a result set that shows which vendors are being paid from more than 1 account. 2. Write a query that returns the Count of Invoices for each vendor 3. Write a query that returns the InvoiceNumber and balance due for every invoice that has a balance. 4. Write a query that returns the total amount invoiced for each Account. 5. Write a query that calculates the average invoice amount for the vendors in California. 6. Write a query that returns the Sum of the Invoice Totals for Each Vendor 7. Write a query that returns the Average of Invoice Totals for all invoices ordered by region of vendor. 

*/ 

Need whole code written out! Please let me know if table names are missing!

Thanks

l Columns TermaitikPk, int,not null) Cri not nul eDa not hull igger i Statisti EE dbo Vendofs bo.Vendors Columns e VendortD ipK int noth s1 warc VendorAddress1 (varchar(50x n vendorAddress2 (varchar(50), null) ull) VendorState (char(2), not null) vendorZipCode (varchar(20), not null) vendorphone (varchar(50), null) VendorContactLName (varchar(50), null) vendorContactF Name (varchar(50), null) em DefaultTermsID (FK, int, not null) om DefaultAccountNo (FK, int, not null) eys , ntt 5 e e e