Create a view named productsummary

Assignment Help PL-SQL Programming

Reference no: EM13167093

Create a view named OrderItemProducts that returns columns from the Orders, OrderItems, and Products tables.

This view should return these columns from the Orders table: OrderID, OrderDate, TaxAmount, and ShipDate.

This view should return these columns from the OrderItems table: ItemPrice, DiscountAmount, FinalPrice (the discount amount subtracted from the item price), Quantity, and ItemTotal (the calculated total for the item).

This view should return the ProductName column from the Products table.

5. Create a view named ProductSummary that uses the view you created in exercise 4. This view should return some summary information about each product.

Each row should include these columns: ProductName, OrderCount (the number of times the product has been ordered), and OrderTotal (the total sales for the product).

6. Write a SELECT statement that uses the view that you created in exercise 5 to get total sales for the five best selling products.

Reference no: EM13167093

Questions Cloud

Data analysis assignment : STATS 201 / 208 Data Analysis, The data sets for the assignment available on Cecil and include header lines. It is your responsibility to back up your computer files. If you are using your own computer, it is your responsibility to ensure that you ca..

Show the design of a modulo 7 asynchronous counter : Using positive edge triggered flip flops, show the design of a modulo 7 asynchronous counter that counts: 7,6...1,7, etc. You may assume that your flip flops have asynchronous Set and Reset inputs available. (Hint: Connect Q to the clock input of the..

C programs hat print out the max, min, and the average value : Write three C programs that print out the max, min, and the average values of the data file included below. Be sure to include the outputs of the programs in your solutions. Use three data file structures (counter, sentinel, and neither counter/senti..

How can these be used to compare : Using the Internet, search for commercial IDPS systems. What classification systems and descriptions are used? How can these be used to compare the features and components of each IDPS? Breifly compare the different classifications of systems you ..

Create a view named productsummary : Create a view named ProductSummary that uses the view you created in exercise 4. This view should return some summary information about each product.

Regular expression and regular sets that is not solvable : Give an example of a problem about FSAs, Regular Expression and Regular Sets that is not solvable?

Add three rows to the downloads : Add three rows to the Downloads table: one row for user 1 and product 2; one for user 2 and product 1; and one for user 2 and product 2. Use the GETDATE function to insert the current date and time into the DownloadDate column.

Write a program in which a ball is released : Write a program in which a ball is released from a user-defined height and free-falls to the ground. The ball is pulled by earth's gravity of 9.8 m/sec 2 . Assume that each pixel represents 1 cm. Once the ball hits the ground

For each of these four modifications : For each of these four modifications, compute and graph the effects on the original system. Explain in words the effect when the multiprogramming level, N , is small and when N is large.

User Account

All Pages