Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Write formal and conversational proposals

Answered: 1 week ago

Question

2. To compare the costs of alternative training programs.

Answered: 1 week ago

Question

1. The evaluation results can be used to change the program.

Answered: 1 week ago