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 2 3 29 new 75 5 7 10 97 TOTAL 112 10 10 15 147