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(*) review 1 0 0 0 1 fixed 17 0 1 2 20 closed 19 5 1 3 28 new 75 5 8 9 97 TOTAL 112 10 10 14 146