Question: You are given a database in a MS Access file called DBP-e14-Cape-Codd that contains data collected in an outdoor sports retail store. The retail store

You are given a database in a MS Access file called DBP-e14-Cape-Codd that contains data collected in an outdoor sports retail store. The retail store hired you as a data analyst to answer questions in order to help them make business decisions that will help them grow. Write the SQL statement for each query and save them in MS Access as Q1, Q2, Please submit the MS Access and MS Word to help speed the grading turnout! in Blackboard. (to help you answer these questions, you shoud practice running the practice SQL queries shown in the videoes). Query Question SQL Statement

7 List all records from retail_order and order_item tables for the year 2014. Sort by order number and SKU of Order_Item

8 For every department, show the average order item price

9 Which manager had the largest amount (quantity) of item-orders?

10 For every store (storeNumber), how many departments are there?

11 How much total money (extendedprice) did we make from each buyer?

12 How much total money (extendedprice) was each manager responsible for?

You are given a database in a MS Access file called DBP-e14-Cape-Codd

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You are given a database in a MS Access file called 'DBP-e14-Cape-Codd' that contains data collected in an outdoor sports retail store. The retail store hired you as a data analyst to answer...

You are given a database in a MS Access file called DBP - e 1 4 - Cape - Codd that contains data collected in an outdoor sports retail store. The retail store hired you as a data analyst to answer...

Write the SQL statement for each query so that the physician can run them at a later time. Using Microsoft Access to test the queries, can someone help with the complete SQL Statement based on their...

Using Microsoft Access, can someone help with the full sql statements based on their respective question to ensure it properly functions? Thank you You are given a database in a MS Access file called...

You are given a database in a MS Access file called Clinic that contains data collected in a physician practice. The physician hired you as a data analyst to answer questions the physician needs...

INFS 3 3 9 0 Assignment 2 ( SQL P 1 ) 1 Structured Query Language ( SQL ) Instructions In this project, we are going to practice using Microsoft Access to run SQL queries. From a larger perspective,...

Callahan (2009) conducted a study to evaluate the effectiveness of physical exercise programs for individuals with chronic arthritis. Participants with doctor-diagnosed arthritis either received a...

The central limit order book of Air Liquide, a French Firm that trades on the Paris Bourse, is currently as follows: a. Vincent Jacquet wishes to buy 1,500 shares and enters a market order to buy...

REGRINE Question 7 of 1 3 0 2 : 5 0 7 m EAR - ller aline Students = Baker College Undergraduate Business Exam Formation Management Systems - Information Management Processes and Procedures is the...

3. Discuss the concerns of upper-level and mid-level managers and trainers in needs assessment.

1. Discuss the role of organization analysis, person analysis, and task analysis in needs assessment.

4. What are the advantages and disadvantages of the Ulysses Program compared to more traditional ways of training leaders such as formal courses (e.g., MBA) or giving them more increased job...