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.33 KB | None | 0 0
  1. Select e.LastName from Products as p
  2. join [Order Details] as od
  3. on p.ProductID = od.ProductID
  4. Join Orders as o
  5. on o.OrderID= od.OrderID
  6. join Employees as e
  7. on e.EmployeeId=o.EmployeeID
  8. join suppliers as s
  9. on s.SupplierId=p.SupplieriD
  10. group by e.LastName
  11. having count(distinct s.SupplierId)>7
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement