Write a trigger to automatically update inventory of books in the books table after a book is sold. Name this trigger as your own last name. Compile the trigger. A partial code and output of this step is shown below. You should, however, create a screenshot of the complete code and complete output and paste it in a Word document.

Test the trigger to see if it works properly by doing the following:

(a) Display the beginning inventory of books (see an example below). Please create a screenshot of the complete statement and its output.

(b) Sell 9 units/copies of the book that has the following ISBN: 3957136468. Create and paste a screenshot of this step showing complete statement and its output in the Word document. (c) Display books inventory again the book tiled "Holy Grill of Oracle" should now have been reduced by 9 units. Create and paste a screenshot of this step showing complete statement and its output in the Word document.