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(*) new 1 0 1 0 2 tested 3 0 0 0 3 review 3 0 3 2 8 defer 4 1 31 2 38 active 8 14 127 15 164 closed 134 15 35 28 212 fixed 202 18 144 20 384 TOTAL 355 48 341 67 811