Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Homework #3 Log into your online Oracle account (livesqloracle.com) run the bookstore database script. Then write and run SQL statements for the queries described below.
Homework #3 Log into your online Oracle account (livesqloracle.com) run the bookstore database script. Then write and run SQL statements for the queries described below. The bookstore script is available in Canvas (Files > Data Files links) and bookstore ER diagram is shown below. Create a new Word document, write your full name at the top, and place a screenshot of cach of the following two problems in the given order. Each screenshot should show your account email, complete SQL statement, and complete output of the statement - all in a single screenshot. Your query output should display column captions that look like the sample output shown with each query (Query#l) 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 ollowing three categories: children, cooking, and computers. NOTE: sales are recorded in the 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. table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started