Create a stored procedure named spbalancerange that accepts three optional parameters. the procedure should return a result set consisting of vendorname, invoicenumber, and balance for each invoice with a balance due, sorted with largest balance due first. the parameter @vendorvar is a mask that's used with a like operator to filter by that vendor name, as shown in figure 15-5. @balancemin and @balancemax are parameters used to specify the requested range of balances due. if called with no parameters or with a maximum value of 0, the procedure should return all invoices with a balance due.