Using the AP (Accounts Payable) Database in Murach's MySQL 5th edition:

1. Calculate the average invoice amount by vendor_id.

2.Modify question #1 to display the vendor_id greater than 80.

3. List the highest invoice_total for each vendor_id.

4. Show the number of invoices for all vendor in California State.

5. Show the number of invoices for each vendor and sum of total_invoices by vendor_id, and show the summary row to show the sum of

total_invoices for all vendor_id.

Please use MySQL Workbench if possible to run queries.