Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Adventureworks table (http://www.go4expert.com/forums/adventureworks-table-t29159/)

appstester 3Oct2012 18:22

Adventureworks table
 
Hi,

I am a newbie on MS SQL 2008 and wanted your help with SQL query on Adventureworks database.

--
Part a. For every Product, show me itís lowest price in History, Highest Price in History, the difference between the 2 prices, Count of SalesDetails, Sum of LineTotal.

Part b. Create a SP that passes a minimum SalesDetails Count. Results will be filtered by Products that only have a SalesDetail Count greater than the number given by the user at runtime.

--

Was wondering if you can give some idea on how to tackle this question, i am completely confused as to where to start this from (which table to choose).

Appreciate your time and help.

Regards,
MJ


All times are GMT +5.5. The time now is 15:36.