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