$1-$ Create a procedure that given a vendorid will return all the unpaid invoices.

$$Alter #$1$ to display a message such as : There are $1$ unpaid invoice for vendor id $37$

$2-$ Create a proc that returns the total invoices for a specified year and month.$$

$3-$ Create a proc that returns the number of unpaid invoices along with the total balance for a given vendor

$4-$ Create a proc that returns the invoices given a year.$$

$($Make year an optional parameter$)$

$5-$ Create a proc that returns the number of unpaid invoices along with the total balance for a given vendor

$($vendor is optional parameter$)$

$6-$ Create a proc that given a state returns the list of vendors.$$

$$ Display a message if there are no vendors from that state