[sqlite] Question about expected query result??

[Shawn Anderson]

I have the following table/data

ClientIP                ClientDomain
63.149.28.33    mail.serverlocation.com
63.149.28.33    mail.serverlocation.com
63.149.28.33    mail.serverlocation.com
63.149.28.33    mail.serverlocation.com
211.141.67.7    xmailserver.org
211.141.67.7    xmailserver.org
211.141.67.7    xmailserver.org
68.80.189.111   ravensorb
128.205.7.58    acsu.buffalo.edu
66.35.250.206   sc8-sf-list1.sourceforge.net
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
128.205.7.57    acsu.buffalo.edu
68.85.92.99     eye-catcher.com

When I run the following query, I get back 0 results -- anyone have any
thoughts? I am expecting to get back 3 records.

SELECT 
        DISTINCT ClientIP, ClientDomain, COUNT(ClientDomain) AS
ClientDomainCount
FROM 
        SMTPLog 
WHERE 
        ClientDomainCount > 1 
GROUP BY 
        ClientIP
ORDER BY 
        ClientDomainCount DESC, ClientDomain ASC