COUNT(expr)

[vronsky]

pls pls pls.... because i don't remember....

if i have a table 'boys' with boolean field 'good'

can i do

SELECT count(*) as all ,count(good=0) as bad , count(good=1) as good FROM boys

????

or better, which expressions support sql function COUNT() ??

[Lars_Berg]

select count(*) as allboys,
       sum(case when not good then 1 else 0 end) as bad, 
       sum(case when good then 1 else 0 end) as good 
  from boys