Write a procedure called Vendor_info that takes in a VendorName asan input Parameter. This procedure has three output parameters, InvoiceTotal, InvoiceCount, and InvoiceAvg. [Vendor, Invoices Table]. Your procedure should first validate that the vendor exists. If it doesn’t throw an error. If the vendor exists then calculate the sum of invoice totals for each vendor, the count of Invoices for each Vendor, and the Average Invoice Totals for each vendor and put that into a appropriate Variables. Computer ScienceEngineering & TechnologyMYSQL CIS 435

Order your essay today and save 20% with the discount code ESSAYHELP