This blog shows how to use the Count funtion to get the count of the desired columns.
Example:
SELECT ProductNames, COUNT(ProductID) ProductCount
FROM DBO.Products
GROUP BY ProductNames
ORDER BY ProductNames
COUNT() - this is the function used to get the count.