TAN: Summary SQL

[Rick Measham]

I know this is tangential to this list's purpose, but I figure 
someone here can help me out with some SQL.

I have a table with a 'status' column. What I need it a count of each 
status so that my result would be:

count | status
--------------
  213 |    1
   90 |    3
  122 |    2
Where the sql would be something like:
SELECT count(status), status FROM table WHERE condition
Thanks for your help and for your forgiveness for an OT question.

Cheers!
Rick
--
--------------------------------------------------------
            There are 10 kinds of people:
  those that understand binary, and those that don't.
--------------------------------------------------------
  The day Microsoft makes something that doesn't suck
    is the day they start selling vacuum cleaners
--------------------------------------------------------
"Write a wise proverb and your name will live forever."
   -- Anonymous
--------------------------------------------------------