1 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.

2. Test the trigger to see if it works properly by doing the following: (a) Display the beginning inventory of books

(b) Sell 9 units/copies of the book that has the following ISBN: 3957136468. (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.

ORDERS CUSTOMERS Orders ustomer Firstname Email Shipdate Shipstreet Shipstate Shipaip Shipcost Sta AUTHOR BOOKS BOOKAUTHOR Reterred Region ISR Ttle ISEN AuthoriD Lname Fname teme QuanstycountPUBLISHER Paideach Discount Contact Phone