Define a view named Paperback. This view should contain the book code, book title, publisher name, and book price for every book that is available in paperback you should have 24 records. Using the Paperback view, write a query to retrieve the book title and publisher name for every book that is priced higher than $10.00. The book titles should be all uppercase. You should have 8 records. After the view is defined, define a new view named OnHand. This view should consist of branch number and a total number of all books on hand (in stock) for each branch. Use a column alias.

Using the OnHand view, write a query to display all the records. Write and execute the statement to create a stored procedure named spBookType. This procedure should give a list of all the different Book Types in the Book table. Each book_type should be listed only once. Execute the spBookType stored procedure.

BRANCH INVENTORY BOOK WROTE PUBLISHER Author Number Author 1515 First Author Last Insert the following record to the AUTHOR table: Your first name Your last name insert into author (author_number, author first, author_last) values ('1515','YourFirst', Yourlast')