Question: Utilizing the Customer-Order Database, return the following results: 1. What is the average price of all items purchased by all customers? 2. Return the total

Utilizing the Customer-Order Database, return the following results:

1. What is the average price of all items purchased by all customers?

2. Return the total number of items purchased

3. How many orders did each customer make? Use the Order_Item table. Select the customerid, number of orders they made, and the sum of their orders.

4. From the items_ordered table, select the item, maximum price, and minimum price for each specific item in the table. Only display the results if the maximum price for one of the items is greater than 190.00.

5. Select the item and price for all of the items in the items_ordered table that the price is greater than 10.00. Display the results in Ascending order based on the price

NOTE: Please Provide the SQL used along with the results

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!

CREATE DATABASE and USE database statement at the beginning of the script in the file of the Sample Database in order for SQL Script in the Sample Database to execute/run correctly If you discover...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Bacteria and other microbes can be used to "clean up" an oil spill by breaking down oil into carbon dioxide and water. Two samples isolated from the Deepwater Horizon leak in the Gulf of Mexico were...

Utilizing the Customer-Order Database discussed in class, return the following results: 1 What is the average price of all items purchased by all customers? 2. Return the total number of items...

Resources: Appendix A, The Home Depot, Inc. Annual Report in Fundamentals of Financial Accounting Writea 1,050- to 1,750-word paper in which you address the following: Does managements assessment of...

hi, expert, thank you very much for your reply, i really want to paid more for your quality answer, but there is no money left from my bank card, that's the last amount i have, but this work is...

Help please. I need as much help as possible. In the excel file are all the questions. The first sheet has all the instructions. The sources are also attached. If I could have answers before...

Jason arrived and settled in Noarlunga with his parents on 1 July 1990 with a permanent intention to remain in Australia. He continued to live in Noarlunga, and worked as a private school teacher...

Share 4 things you learned from reading chapter 1 in the Media and Culture: Mass Communication in a Digital Age , 13th edition, by Richard Campbell, Christopher Martin, Bettina Fabos, and Ron Becker,...

Your professor will give you one o f the following l e v e l o f involvement pieces o f additional information for your assigned role play scenario. Your interviewer will not know this information...

You expect to be paid 1,000,000 euros in 3 months, how do you hedge?

If a photon of energy 12 Mev strikes (a) a hydrogen nucleus and (b) a nitrogen nucleus, each assumed to be at rest, what will be the energies of recoiled nuclei if the photons are scattered (a) at 45...

Write a C program to create a list of books details. The details of a book include title, author, publisher, publishing year, no. of pages , price Perform the following with respect to the list of...

If a neutron having a kinetic energy of 5.7 Mev strikes a 2HE nucleus at rest head-on, what will be the maximum recoil kinetic energy of 2He+?

A Pelton wheel is to be designed to the following specifications : Power Head Speed Overall efficiency ... 11948 kW ... 381 m ... 750 r.p.m. ... 86% Jet diameter not to exceed times the wheel 1 16...

What challenges do MSMEs face in their operations( These could be financial or non-financial challenges)

Create an example of an entity with an optional attribute.

Using OLAP Query 1 shown in Figure 9.11 (based on data from Figure 9.7) as a starting point, give an example that illustrates a drill up operation.

Create an example of an entity with a derived attribute.

Suppose a manager is using maximum EMV as a basis for making a capacity decision and, in the process, obtains a result in which there is a virtual tie between two of the seven alternatives. How is...

Refer to Problem 1. Suppose after a certain amount of discussion, the contractor is able to subjectively assess the probabilities of low and high demand: P (low) = .3 and P (high) = .7. a. Determine...

Contrast maximax and maximin decision strategies. Under what circumstances is each appropriate?