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
     
  2. vickya4n

    vickya4n New Member

    Joined:
    Aug 23, 2016
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Gender:
    Male
    Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice