SELECT c.CategoryID, CategoryName, COUNT(distinct ProductID) AS '# of Products' FROM categories AS c
INNER JOIN products AS p ON c.CategoryID = p.CategoryID
GROUP BY CategoryID, CategoryName;