I need some assistance on selecting and counting records from a database.

Every record in the table will have a category example 'News' and 'Sport'. Let say News has 17 category's and sport has 11. How can I list all category's and count the total amount of records within that category.

so. . .

News (17)
Sport (11)