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 and an Invoice Due Date that is less than 30 days from today. 4. Write a query that returns the total amount invoiced for each Account. 5. Write a query that calculates the number of invoices and 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. */