SQL newbie question:

Hi Everyone:

I have a table with two columns:  names and band .   There are about 50000
names in "names" column and five bands (1-5)in the "band" column.    Each
name can belong to one, more than one or all 5 bands.  Something like:

names         band
___________________

jim            2
john           1
mark           4
jim            4

Etc, etc...

I am trying to figure out how many names (out of 50000) are members of , say
, all 5 bands or only 4  bands etc.  That is , for example, how many unique
names I have in , say, bands 1 and 2 and 3
I tried something like this:

SELECT COUNT (names) FROM <my table> WHERE band = 1 AND band = 2 AND band =
3;

So , the above select statement was supposed to tell me how many users
belong to band 1,2 and 3.   I am always getting result of "0" but this is
not true.
Thanks for help.

Nick