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
Rows: 8