How do you count number of item category from specific column

Databases
1

Hi,
I’ve been googling it and cannot find the solution I want to solve.
Say, given I have a stack of movie DVDs I want to record into the database which look like bellow;


id         category            title
1          Action               aaa
2          Action               bbb
3          Comedy            ccc
4          Action               ddd

The problem is how do I count how many Action movie DVDs I have got in the database.

Any idea suggestion would be greatly appreciated,
Ket

2

Look at COUNT and GROUP BY