Question: For each customer, list the customer ID, the number of orders from that customer, and the ratio of the number of orders from that customer

For each customer, list the customer ID, the number of orders from that customer, and the ratio of the number of orders from that customer to the total number of orders from all customers combined. (This ratio, of course, is the percentage of all orders placed by each customer.)

Step by Step Solution

★★★★★

3.45 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Query first get the total number of orders SELECT COUNT OrderID AS AllOrders FROM OrderT then g... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (1822).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

For each customer, list the CustomerlD and the total number of orders placed in 2015.

Complete the following tasks. In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram. 1. Design a database to...

For each customer, list the CustomerID and total number of orders placed.

. For each customer, list the customer ID, the number of orders from that customer, and the ratio of the number of orders from that customer to the total number of orders from all customers combined....

Use the db_pvfc12_big database in Teradata SQL Assistant. Create a .SQL file that provides queries to the following Problems in the textbook: 15) 5-74. For each payment made on or after March 10,...

Write SQL to answer the following questions based on the Pine Valley Furniture Company database. Note: the Pine Valley database is the one containing four tables (Customer, Order, OrderLine, and...

please help with Questions 16, 17 and 18 Modify the Product_T table by adding an attribute QtyOnHand that can be used to track the finished goods inventory. The field should be an integer field of...

Produce a list of all customers ( all attributes ) . Display a list of all items. Your list should include item ID , item name, and price. Provide a list of all suppliers. The list should include...

2a A plane in a cubic lattice makes intercepts of a, and 3 crystallographic axes, respectively. The Miller indices for this plane are: (a) (243) (b) (342) (c) (634) (d) (123) with the three

In Year 1 in a project to develop Product X, Lincoln Company incurred research and development costs totaling $10 million. Lincoln is able to clearly distinguish the research phase from the...

Question 1 ( 1 0 points ) Saved Use the command ADD to change column characteristics. True False

What other remedies would you prescribe if you were in Tim Fentons shoes?

Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The results of...

Write the SQL code to generate the total hours worked and the total charges made by all employees. The results are shown in Figure. SumOfSumOIASSIGN HOURS SumOfSumOfASSIGN CHARGE 90.6 7612.64

Write the SQL code to generate the total hours worked and the total charges made to all projects. The results should be the same as those shown in Figure.

Fitness Machine A fitness center bought a new exercise machine called the Mountain Climber. They decided to keep track of how many people used the machine over a 3-hour period, Here X is the number...

REC The Time Value of Money Rebecca is thinking about investing in a piece of land that costs $85,000. She is certain that next year the land will be worth $91,000, a gain of $6,000! Given that she...

Option to delay Look back at the Malted Herring option in Section 22-2. How did the company's analysts estimate the present value of the project? It turns out that they assumed that the probability...