Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select E.EmployeeID from Employees as E join Orders as O on O.EmployeeID = E.EmployeeID
- join [Order Details] as OD on O.OrderID = OD.OrderID
- join Products as P on P.ProductID = OD.ProductID
- group by E.EmployeeID
- having count(distinct P.ProductID)>70
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement