title: AdventureWorks - Selling Price Problem - Queries Microsoft SQL Server
body: <p>Just looking for someone who has downloaded AdventureWorks data and done queries with them.</p>
  
  <p>I was looking for someone to explain the difference between list price and unit price.</p>
  
  <p>I filtered to productid 749 and 83% of the time it is being sold to the customer with listprice = unitprice.</p>
  
  <p>I did some digging to see if there were any discounts etc. with the below query which did not come up with an answer.  Is there something I am missing?</p>
  
  <pre><code>select *
  from sales.specialoffer
  where SpecialOfferID = 1;
  
  select SOH.customerID, 
  
      SOH.orderdate, 
      pp.listprice, 
      sod.unitprice, 
      sod.ProductID,  
      sod.SpecialOfferID, 
      SOD.UnitPriceDiscount, 
      sr.SalesReasonID,sr.name, 
      sr.ReasonType 
  from sales.SalesOrderHeader SOH
  inner join sales.SalesOrderDetail SOD
      on soh.SalesOrderID = sod.SalesOrderID
  inner join production.Product PP
      on SOD.ProductID= PP.ProductID
  left join sales.SalesOrderHeaderSalesReason SOHSR
      on soh.SalesOrderID = sohsr.SalesOrderID
  left join sales.SalesReason SR
      on  SOHSR.SalesReasonID = SR.SalesReasonID
  where standardcost &gt;0
  and PP.listprice != sod.unitprice
  and pp.productid = 749
      ;
  </code></pre>