How to count

[shaifful]

Hi, I have a table "gender" which contains W and M, how
can I calculate total count of W/M from the table.

 

[Duane Hookom]

Select Gender, Count(*) as NumOf
FROM aTable
GROUP BY Gender;