5.  CREATE a stored PROCEDURE named spVendorMax that accepts 2 parameters @InvTotal AND @VenZip AND RETURNS the VendorName, AND Maximum InvoiceTotal FOR those vendors who have a VendorZipCode LIKE 93711 AND THEN grouped BY the VendorName HAVING a Maximum InvoiceTotal greater than OR equal TO the @InvTotal.
Sort BY the highest maximum InvoiceTotal FIRST.
Hint: IN the EXEC, send a zero VALUE FOR @InvTotal AND THEN the zip code string.




CREATE PROC spVendorMax
@InvTotal money = 0,
@VenZip VARCHAR(5) = '%'

AS

SELECT VendorName, @InvTotal AS 'Max Invoice Total'
FROM Invoices JOIN Vendors
     ON Invoices.VendorID = Vendors.VendorID
WHERE InvoiceTotal >= @InvTotal AND VendorZipCode LIKE @VenZip
ORDER BY InvoiceTotal;