Use the bookstore database in order to run some reports for upper management. The SQL file for
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.
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?
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi