Develop a stored procedure that will take a state abbreviation as a parameter and list the name of the state, vendor, and total
amount still owed on invoices for the vendor with the highest amount still owed in that state, i.e. list the vendor (along with their state and amount owed) with the most money still owed for a given state. (List only vendors to whom a positive amount is still owed; omit vendors to whom no amount is owed). The Canvas assignment includes a link to a script for a partially completed stored procedure called owed_to_state_vendors. Review the code, including the comments, to understand the requirements of the stored procedure. You will complete the stored procedure, using the comments as a guide. Use of a CTE is advised to accomplish this task.
