Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the bookstore database in order to run some reports for upper management. The SQL file for this is already in your Playground, called gravity_books.sql.

Use the bookstore database in order to run some reports for upper management. The SQL file for this is already in your Playground, called gravity_books.sql.

Upper management has some questions they need answered, but are unsure what exact data/fields will help them best answer the questions. You'll need to think about what their actual problem is and program a query to gather the data needed.

The questions are:
1. Which language should they stock more books in?
2. What author should they discontinue stocking?
3. Who are the 10 best customers?
4. Gravity Books is looking to add a warehouse to help optimize shipping. Where should they locate that warehouse?

For formatting, you want this to be a report written to upper management. There should be 4 sections, one for each question, and it should include the following pieces:
1. What was the query you used, both the SQL statement and explained in plain English for someone who doesn't know SQL.
2. Why does that particular query best answer the question over pulling any other data from the database?
3. Show a table of the results from the query and explain in plain English what those results are showing in terms of the question asked. What is your final answer to the question based on the results and why?
4. What you think the business should do based on the information you gathered?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

I can help you create the report for upper management using the provided bookstore database Lets address each question one by one Question 1 Which language should they stock more books in 1 Query sql ... 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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions