Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select SupplierName, count(distinct(Quantity)) from Suppliers
- join Products on (Suppliers.SupplierID=Products.SupplierID)
- join OrderDetails on (Products.ProductID = OrderDetails.ProductID)
- group by SupplierName
- order by count(distinct(Quantity)) desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement