status count(case when type='code' then 'x' end) count(case when type='doc' then 'x' end) count(case when type='new' then 'x' end) count(case when type NOT IN ('code','doc','new') then 'x' end) count(*) TOTAL 355 48 341 67 811 active 8 14 127 15 164 closed 134 15 35 28 212 defer 4 1 31 2 38 fixed 202 18 144 20 384 new 1 0 1 0 2 review 3 0 3 2 8 tested 3 0 0 0 3