Question: With this question I need to make a view that will display the items sold within the last 18 months. I am stuck on making

With this question I need to make a view that will display the items sold within the last 18 months. I am stuck on making the view for the 18 months. I need this in Microsoft Sql, Not Oracle.

With this question I need to make a view that will display

5. Write a view that will display the items sold within the last 18 months. You can find the items sold in LINE table and product information in PRODUCTS table [5] LINE NV NUMBER LINE NUMBER PROD CODE LINE UNITS LINE PRICE LINE AMOUNT 1001 4243213 1200247 69.99 69.99 1001 1003 4243213 85 85 1003 0637032 1003 1200247 69.99 69.99 PRODUCT PROD QOH PROD MIN PROD PRICE PROD DISCOUNT VEND NUMBER PROD CODE PROD DESCRIPT PROD NDATE 4243213 2015-11-03 00:00:00.000 8 Snow Suit 21225 0.05 21344 Mens Training Shoes 2015-12-13 00:00:00.000 32 15 0637032 Womens Basketbal... 2015-02-24 00:00:00.000 237 69.99 1200247 100 21344

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!

Dialogue 3 Nygaard Jewelers Introduction Bob Nygaard of Nygaard Jewelers returned to his store in the spring of 20x5 angry and depressed."We just lost our lease; I don't see how we can make it...

Please help me answer this question Background Veronese 81 Tiffany Inc. is a medium-sized business located in Elmira, Ontario. It sells designerjewelry to specialty stores through Canada as well as...

Case #3 ? Performance Drinks -A further study of: Regression Analysis Contribution Margin Reporting Cost-Volume-Profit Analysis Differential Analysis Capital Budgeting Background: Performance Drinks,...

The team that Wasn't Case Study PFB in pictures Project Overview The project involves a case study on a detailed team dynamic. You have to critically examine the information in the case study,...

Bill Smith receives a range of 1:1 supports to maintain his routine and equilibrium in order to function and participate in everyday life and to encourage him to develop new and improve existing...

Paper critique to this article below: Using Virtual Teams to Manage Complex Projects: A Case Study of the Radioactive Waste Management Project Samuel M. DeMarie Assistant Professor Department of...

Paper critique to the case study regarding on :- Using Virtual Teams to Manage Complex projects : A case Study of the Radioactive Waste Management Project. details & key explanations Using Virtual...

Indicate (by letter) the way each of the investments listed below most likely should be accounted for based on the information provided.

Compare and contrast the Tannenbaum-Schmidt Continuum of Leader Behavior with Fiedler's Leadership Contingency Model.

Using the balance sheet data for Software Solutions, what is the capital structure? debt 5 4 % , equity 4 6 % debt 5 6 % , equity 4 4 % debt 5 3 % , equity 4 7 % debt 5 5 % , equity 4 5 %

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...