Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select EmployeeID, LastName+''+FirstName, ProductName, kolvo
- from Employees cross apply
- (
- select top(3) ProductName, sum(O.Quantity) as kolvo
- from Orders join [Order Details] on Orders.OrderID=[Order Details].OrderID,
- [Order Details] O join Products on O.ProductID=Products.ProductID
- where Employees.EmployeeID=Orders.EmployeeID
- group by ProductName
- order by sum(O.Quantity)
- ) Customer
- Order by EmployeeID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement