(Query #1)

Display title of the book whose title contains the word MANAGE along with first name and last name of the author who wrote this book. Query output is shown below for your guidance.

Query #2

The bookstore manager wants to know how many books have been sold in the following three categories: children, cooking, and computers. NOTE: sales are recorded in the ORDERITEMS table. Write an SQL statement that displays an output showing book category along with number of books sold in these three categories. Query output is shown below for your guidance.

ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Emall Address CI Sta Zi Referred Reglon BOOKAUTHOR AUTHOR BOOKS ISBN Title Pubdate PublD Cost Retalil Discount Category ISBN AuthorlD AuthorlD Lname Fname ORDER!TEMS | Order# I tem# ISBN Quantity Paldeach PUBLISHER PublD Name PROMOTION Contact Phone Gift Minretail Maxretall