Advertisement
Guest User

Untitled

a guest
Dec 10th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. select EmployeeID, LastName+''+FirstName, ProductName, kolvo
  2. from Employees cross apply
  3. (
  4. select top(3) ProductName, sum(O.Quantity) as kolvo
  5. from Orders join [Order Details] on Orders.OrderID=[Order Details].OrderID,
  6. [Order Details] O join Products on O.ProductID=Products.ProductID
  7. where Employees.EmployeeID=Orders.EmployeeID
  8. group by ProductName
  9. order by sum(O.Quantity)
  10. ) Customer
  11. Order by EmployeeID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement