SHOW SQL CODE WITH OUTPUT

Question 5: 1. Consider the following schema and solve the queries Catalog Book Id Title Author Id Publisher Id Year Price Author Author Id Name City Country Order_Detail Order No Book_Id Quantity a) Get the names of all the books for which an order has been placed. b) Get the title and price of all the books whose price is less than the average price of the books. c) Write a trigger which prints the total quantity ordered for a particular book whenever a neworder is placed