Two Counts In One Query?

[Good Man]

Hi there

I'm wrapping up my first *really* big, complex web application, and in
doing so, I realize that my next tast will be reading some SQL books and
learning how to improve my querying. I really didn't know that i could
work math equations, comparisons, and if clauses right in the statements
themselves.

Anyways, I digress. I'm looking for a way to query the following... I have
a database full of people, where the Membership field is either a '1' or
'0'. I'd like to get the total counts for both situations in one query.
Something that will give me:

RegisteredMembers | 332
UnregisteredMember | 543
I can obviously get this result using two queries:
+
SELECT COUNT(*) AS RegisteredMembers FROM Contacts WHERE Membership='1'
and
SELECT COUNT(*) AS UnRegisteredMembers FROM Contacts WHERE Membership='0'
but can I do this in one query?

THANKS!!

[Bill Karwin]

Good Man wrote:

I can obviously get this result using two queries:
+
SELECT COUNT(*) AS RegisteredMembers FROM Contacts WHERE Membership='1'
and
SELECT COUNT(*) AS UnRegisteredMembers FROM Contacts WHERE Membership='0'

SELECT Membership, COUNT(*)
FROM UnRegisteredMembers
GROUP BY Membership

Regards,
Bill K.

[Good Man]

Bill Karwin <bi**@karwin.com> wrote in
news:d8********@enews3.newsguy.com:

Good Man wrote:

I can obviously get this result using two queries:
+
SELECT COUNT(*) AS RegisteredMembers FROM Contacts WHERE
Membership='1' and
SELECT COUNT(*) AS UnRegisteredMembers FROM Contacts WHERE
Membership='0'

SELECT Membership, COUNT(*)
FROM UnRegisteredMembers
GROUP BY Membership

Thank you Bill.

I can't wait to sit down with a good SQL book this summer!