[thelist] SQL help please

[CDitty]

Hello all.   I hope all is well on Xmas eve.

I am trying to get a count of all the unique email addresses in my 
database.  For some reason, my sql statement only returns the total 
count.  I know this should be a simple one, but I didn't see anything in my 
books.  Here is my sql.

select distinct count(emailaddr) from scratch_log where gameid = '1' and 
playedwhen like '12242000%'


Thanks and a merry xmas/happy holiday.

Chris