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