Write 2 SQL quires

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

SCRIPT:

Book Title Author First Name Author Last Name HOW TO MANAGE THE MANAGER WILLIAM WHITE