SHOW SQL CODE WITH OUTPUT

take random data

Question 4: 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 details of all the books whose price greater than the average price of the books. b) Get the names of all the books for which an order has been placed. c) Get the names of all the authors who have more than two books in the catalog