I am doing the following SELECT statement to see how many Reps each of my Manufacturers have in my database, this is working nicely:

```
SELECT ManufacturerId, COUNT(*) AS RepCount 
FROM ManufacturerSalesReps WHERE IsDeleted=0
GROUP BY ManufacturerID
ORDER BY  COUNT(*) 

```

So this gives me the ManufacturerId and the number of reps but what i really need is the number of manufacturers at different rep counts. So I want to GROUP the results from the above SELECT by RepCount.

How do I accomplish this?