select * from Sales.SalesOrderDetail
select 'sales order ID'= SalesorderID,'Average value'=Avg(lineTotal) from Sales.SalesOrderDetail
Group by SalesOrderID
Thursday, 10 October 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
Subscribe to:
Post Comments (Atom)
-
select SalesPersonID as 'Sales Person ID', TerritoryID as 'Territory ID', SalesQuota as 'Sales Quota' from Sales....
-
Q2. What are the lines of latitude? Ans. Lines of Latitude are the Imaginary Horizontal lines running East to West circling the Earth. Th... -
Niit NIIT NIIT D C Chowk New Delhi 1800 102 6448 CALL DIRECTIONS NIIT NIIT HD-7, 2nd Floor, Main Metro Road, Opp. Metro Pillar No....
No comments:
Post a Comment