Wednesday, 11 September 2013

5.Display a report containing the sales order ID and the average value of the total amount greater than $ 5,000 in the following format. (Use the AdventureWorks database)


select * from Sales.SalesOrderDetail
select 'sales order ID'= SalesorderID,'Average value'=Avg(lineTotal) from Sales.SalesOrderDetail
Group by SalesOrderID
Posted by at
Labels:

1 comment:

  1. Sujan26 September 2013 at 01:54

    select SalesOrderID,'Average Value'=Avg(LineTotal) from Sales.SalesOrderDetail group by SalesOrderID having AVG(LineTotal)>=5000

    ReplyDelete

Subscribe to: Post Comments (Atom)