1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Adventureworks table

Discussion in 'SQL Server' started by appstester, Oct 3, 2012.

  1. appstester

    appstester New Member

    Joined:
    Oct 3, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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
     

Share This Page