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.