I have two tables I need information from, `Products` and `Suppliers`. Both these tables have a `SupplierID` column I am trying to use to join them together to retrieve the right info. 

The output I need is `SupplierID` and `ContactName` from the `Suppliers` table. The correct output should contain only two suppliers, so I attempted something like this, but ran into a conversion error converting nvarchar value to a data type int. I am not supposed to count how many products they supply but aggregate functions seem like the best method to me. 

```
SELECT TOP 2 ContactName, COUNT(Products.SupplierID) AS Supply
FROM Products 
LEFT JOIN Suppliers ON Suppliers.ContactName = Products.SupplierID
GROUP BY Products.SupplierID, Suppliers.ContactName
ORDER BY Supply;

```

I have tried many different queries but none will work. I am confused on how to join these tables without running into errors. All the products have a unique ProductID as well. The correct output should look something like this:

```
   7     John Smith
  12     John Sample

```