I am trying to COUNT the bumber of entrants for 2 columns within the same table but the second COUNT has to have a WHERE clause.

SELECT COUNT(winID), count(isClaimed) FROM winners WHERE isClaimed =1

Here I am trying to return the entire number of records (winID - which is an auto-increment field) but only return the number of records from the column isClaimed wher the value = 1.

I am completely stumped. Anyone any ideas?

Thanks.

SELECT COUNT(winID) as winIDtotal,
sum(case when isClaimed=1 then 1 else 0 end) as isClaimedtotal
FROM winners;