--Your SELECT statement for Problem 5 (i.e., suppliers who supply more different products than all others)

--> Correct output of this query for this problem is: 7 Ian Devling 12 Martin Bein

This is what I have so far but it doesn't work.

SELECT s.SupplierID, s.ContactName

FROM dbo.Suppliers AS s INNER JOIN dbo.Products AS p

ON s.SupplierID = p.SupplierID

WHERE p.ProductID NOT IN (SELECT pr.ProductID FROM dbo.Product AS pr

WHERE pr.SupplierID = p.SupplierID)