Kilka największych liczb

0

Witam, mam pewien problem, muszę wyświetlić osobę która sprzedała najwięcej w ostatnich 6 miesiącach w danym regionie. Próbowałem na kilka sposobów ale wszystkie pomysły mi już się wypaliły. KOD:

SELECT AdventureWorks.Sales.SalesPerson.TerritoryID AS TerytoriumID,
[CountryRegionCode] AS Region,
AdventureWorks.Sales.SalesPerson.BusinessEntityID AS Id,
AdventureWorks.Person.Person.FirstName AS Imie,
AdventureWorks.Person.Person.LastName AS Nazwisko,
MONTH(Sales.SalesOrderHeader.OrderDate) AS Miesiąc,
COUNT(Sales.SalesOrderHeader.SalesOrderID) AS IlośćSprzedanych
  FROM [AdventureWorks].[Sales].[SalesTerritory]  INNER JOIN Sales.SalesPerson on AdventureWorks.Sales.SalesPerson.TerritoryID=AdventureWorks.Sales.SalesTerritory.TerritoryID
  INNER JOIN AdventureWorks.Person.Person on Person.Person.BusinessEntityID=Sales.SalesPerson.BusinessEntityID
  INNER JOIN Person.BusinessEntityAddress on Person.BusinessEntityAddress.AddressID = Sales.SalesPerson.BusinessEntityID
  INNER JOIN Person.Address on Person.Address.AddressID = Person.BusinessEntityAddress.AddressID
  INNER JOIN Sales.SalesOrderHeader on Sales.SalesOrderHeader.TerritoryID = Sales.SalesPerson.TerritoryID
  WHERE MONTH(Sales.SalesOrderHeader.OrderDate)<=6 AND YEAR(Sales.SalesOrderHeader.OrderDate) = 2014 
GROUP BY AdventureWorks.Sales.SalesPerson.TerritoryID,
[CountryRegionCode],
AdventureWorks.Sales.SalesPerson.BusinessEntityID,
AdventureWorks.Person.Person.FirstName,
AdventureWorks.Person.Person.LastName,
MONTH(Sales.SalesOrderHeader.OrderDate)
0

Nie mam tej bazy ale brakuje mi top 1 i order by

SELECT TOP 1 AdventureWorks.Sales.SalesPerson.TerritoryID AS TerytoriumID,
[CountryRegionCode] AS Region,
AdventureWorks.Sales.SalesPerson.BusinessEntityID AS Id,
AdventureWorks.Person.Person.FirstName AS Imie,
AdventureWorks.Person.Person.LastName AS Nazwisko,
MONTH(Sales.SalesOrderHeader.OrderDate) AS Miesiąc,
COUNT(Sales.SalesOrderHeader.SalesOrderID) AS IlośćSprzedanych
  FROM [AdventureWorks].[Sales].[SalesTerritory]  INNER JOIN Sales.SalesPerson on AdventureWorks.Sales.SalesPerson.TerritoryID=AdventureWorks.Sales.SalesTerritory.TerritoryID
  INNER JOIN AdventureWorks.Person.Person on Person.Person.BusinessEntityID=Sales.SalesPerson.BusinessEntityID
  INNER JOIN Person.BusinessEntityAddress on Person.BusinessEntityAddress.AddressID = Sales.SalesPerson.BusinessEntityID
  INNER JOIN Person.Address on Person.Address.AddressID = Person.BusinessEntityAddress.AddressID
  INNER JOIN Sales.SalesOrderHeader on Sales.SalesOrderHeader.TerritoryID = Sales.SalesPerson.TerritoryID
  WHERE MONTH(Sales.SalesOrderHeader.OrderDate)<=6 AND YEAR(Sales.SalesOrderHeader.OrderDate) = 2014 
GROUP BY AdventureWorks.Sales.SalesPerson.TerritoryID,
[CountryRegionCode],
AdventureWorks.Sales.SalesPerson.BusinessEntityID,
AdventureWorks.Person.Person.FirstName,
AdventureWorks.Person.Person.LastName,
MONTH(Sales.SalesOrderHeader.OrderDate)
ORDER BY COUNT(Sales.SalesOrderHeader.SalesOrderID)  DESC

1 użytkowników online, w tym zalogowanych: 0, gości: 1