Create a stored procedure named branchInventory that will display the books available by branch. Display the book code, book title, publisher code, book type, price, paperback indicator, and the inventory on hand.
a. Display the contents of the stored procedure here:
b. Run your procedure for branch 1. What construct did you use to run this query?
c. Insert the results of running the stored procedure here: