Advertisement
Guest User

Untitled

a guest
Oct 14th, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. Select E.EmployeeID from Employees as E join Orders as O on O.EmployeeID = E.EmployeeID
  2. join [Order Details] as OD on O.OrderID = OD.OrderID
  3. join Products as P on P.ProductID = OD.ProductID
  4. group by E.EmployeeID
  5. having count(distinct P.ProductID)>70
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement