Execute the following script in Query Editor to demonstrate the use of advanced SQL Server 2005 T-SQL features to analyze the performance of business customers.

USE AdventureWorks

GO

select  c.LastName+', '+c.FirstName

                  as [Customer Name],

  '$'+convert(varchar,sum(convert(money,sod.LineTotal)),1)

                  as TotalSales,

   row_number() over ( order by sum(sod.LineTotal) desc )

                  as 'Revenue Ordinal',

   count(distinct soh.SalesOrderID)

                  as NoOfOrders,

   row_number() over ( order by count(distinct soh.SalesOrderID) desc )

                  as 'NoOfOrders Ordinal'

from Sales.SalesOrderHeader soh

  inner join Sales.SalesOrderDetail sod

            on soh.SalesOrderID=sod.SalesOrderID

  inner join Person.Contact c

            on soh.ContactID=c.ContactID

group by c.ContactID,

             c.LastName+', '+c.FirstName

order by sum(sod.LineTotal) desc